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 ...
Example in the attached file
=MIN(IF(A1:A10>D1,A1:A10))
Contains array formula: Do not enter the border {}, complete the formula with CTRL + SHIFT + RETURN!
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
I'm looking for something that doesn't need the CNTL, SHIFT, RETURN.
Thanks though
Thanks though