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

12/27/18 Edited 12/09/19

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

Popular Tags:

Comments

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    Try something along the lines of

     

    =MIN(COLLECT([First Column Name]@row:[Last Column Name]@row, [First Column Name]@row:[Last Column Name]@row, @cell > TODAY()))

     

    This will collect all dates that are greater than today and then display the minimum value collected.

  • Genius! This is exactly what I was looking for!

    Thank you so much. 

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    Excellent! Happy to help. yes

Sign In or Register to comment.