I have a range of dates reaching from the past to the future, call it milestones of a project.
I will like to write a formula to extract the latest date of the range of dates that is before todays date.
Example
1-jan-12, 5-jan-12, 15-feb-12, 1-march-12, 25-march-12, 2-April-12, 15-April-12, 30-April-12, 15-may-12
Today: 4-April-12
The date I would like to get through the formula is 2-April-12
Thanks!
Bookmarks