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
