Find "soonest" or closest date in a column of dates.

RPIArchShop

I'd like to find the earliest or Next available date for 3D Printing Dashboard. I'd like to use IF or IFS given that I would like to search only rows with a "Printing" Status.

There are no formulas that seem to help.

Any help would be appreciated

ataberk_teknekaya

Hi RPIArchShop!

Lets say your sheet is something like this,

You can create a report and add that report to a dashboard

Filter the status to printing and sort the due date the oldest to newest. By this way, you can find the closest order.

I hope it helps :)