Formula to calculate the Next [Future] date in a string of dates
I'm looking for a way to find the next task due date. Ideally, I'll be able to look at a row with several date columns, and determine the next date. This would be the MIN Date that is Greater than Today's date.
I can easily get the MIN Date, However, many columns are in the past. I want the next [future] date after today.
This is an array in Excel:
Thanks for any thoughts.
Help Article Resources
Check out the Formula Handbook template!