Help with a Formula?

Paisdais

Hi,

I am working on row of dates and I am trying to get the next due date (from today) in another column. I have tried a couple of formulas but get #UNPARSEABLE. What should the formula be? I am looking for the formula for the cell in yellow.

James Keuning

You want to know which of the dates in the Release Date column is next:

=MIN(COLLECT([Release Date]:[Release Date], [Release Date]:[Release Date], >TODAY()))

This formula grabs all of the dates that are later than today, and gives you the first (MIN) date in that collection.

James Keuning

You want to know which of the dates in the Release Date column is next:

=MIN(COLLECT([Release Date]:[Release Date], [Release Date]:[Release Date], >TODAY()))

This formula grabs all of the dates that are later than today, and gives you the first (MIN) date in that collection.