Forum Discussion
Solved
Find the next date greater than today from a range
I have a range of cells with dates. Some dates are older than today, some are today and several are greater than today. I want to find the next date that is greater than today. E.g. Today is 7/15 ...
Not sure how to referece the range. When I put in A1:A20 I get a #NAME? result.
- Perfect! The AGGREGATE function seems to do it well.
Thank you very much.SteveBoat , you are welcome