Forum Discussion
Formula to locate the date from a list of dates that is less than but closest to a specific date
I have a column of specific dates (sprint end dates). When determining delivery milestone dates for a project, I need to know which sprint a milestone date falls in. I can look it up manually but whe...
Since you didn't state the version of Excel you use, here is a solution designed for 365
= XLOOKUP(milestone, startDate, endDate,,-1)
You can use SUMPRODUCT to obtain the sprint end date:
=SUMPRODUCT((B9>=B2:B7)*(B9<=C2:C7)*C2:C7)Please see attached sample workbook.
Thank you!! That works perfectly!
- You're welcome. Have a good weekend!
