I have series of dates in a row (with some blank cells) and want to return the lowest value, AFTER today's date
Using the MIN function, I can find the lowest date in the row
Using the NOW() function, I can find today's date
I can't figure out how to use either the AND function or an IF statement to return the lowest value after today's date.
Any help is greatly appreciated.
Bookmarks