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 where is the fun in that?
For example: if a project estimate determines a design must be completed by 11/10, I want to know the sprint end date of the sprint it would fall into?
Data Table:SprintStart DateEnd DateOCT24-2110/9/202410/22/2024OCT24-2210/23/202411/5/2024NOV24-2311/6/202411/19/2024NOV24-2411/20/202412/3/2024DEC24-2512/4/202412/17/2024DEC24-2612/18/202412/31/2024 Milestone date:11/10/2024 Sprint End Date:11/19/2024
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 where is the fun in that? For example: if a project estimate determines a design must be completed by 11/10, I want to know the sprint end date of the sprint it would fall into?Data Table:SprintStart DateEnd DateOCT24-2110/9/202410/22/2024OCT24-2210/23/202411/5/2024NOV24-2311/6/202411/19/2024NOV24-2411/20/202412/3/2024DEC24-2512/4/202412/17/2024DEC24-2612/18/202412/31/2024 Milestone date:11/10/2024 Sprint End Date:11/19/2024 Read More
