Forum Discussion

Copper Contributor

Jul 19, 2021

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

excel

SergeiBaklan
Jul 19, 2021
SteveBoat

Or

mathetes

Silver Contributor

Jul 19, 2021

SteveBoat

Another approach is to take advantage of the recent FILTER function.

Assuming dates are in A1:A10,

=MIN(

FILTER(A1:A10,A1:A10>today())

)