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...