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 ...
Let's say the range with dates is A2:A32.
If you have Excel 2019 or Excel in Microsoft 365:
=MINIFS(A2:A32,A2:A32,">"&TODAY())
For earlier versions, use the following array formula confirmed with Ctrl+Shift+Enter:
=MIN(IF(A2:A32>TODAY(),A2:A32))