Formula to calculate the Next [Future] date in a string of dates

Options
pgreene31
pgreene31 ✭✭
edited 12/09/19 in Formulas and Functions

Hello,

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:

{=MIN(IF(A2:J2>TODAY(),A2:J2))}

Thanks for any thoughts.

Β 

Screenshot Array Calc.JPG

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!