Find the most recent date

Christophe AUBRIOT · 10/14/21

Hello everyone,

Is it possible to find the most recent date, from an available date range ?

Thank you very much

Cheryl Collins · 10/14/21

Hi Christophe

I have used the MAX formula to find the most recent date in the past.

The formula would be =MAX([most recent date])

Thanks

Cheryl

Cheryl Collins · 10/14/21

Hi Christophe

I have used the MAX formula to find the most recent date in the past.

The formula would be =MAX([most recent date])

Thanks

Cheryl

Christophe AUBRIOT · 10/14/21

Thank you very much for your help Cheryl.

It's so simple, really !

Cheryl Collins · 10/14/21

No problem Christophe, glad it worked.😊

Best Answer