Find the most recent date

Christophe AUBRIOT ✭✭

10/14/21 in Formulas and Functions

Hello everyone,

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

Thank you very much

0 · Share on FacebookShare on Twitter

Sign in

Try Smartsheet

Best Answer

• 

  Cheryl Collins ✭✭✭✭✭✭

  10/14/21 Answer ✓

  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

  1 · Share on FacebookShare on Twitter

Answers

• 

  Cheryl Collins ✭✭✭✭✭✭

  10/14/21 Answer ✓

  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

  1 · Share on FacebookShare on Twitter
• 

  Christophe AUBRIOT ✭✭

  10/14/21

  Thank you very much for your help Cheryl.

  It's so simple, really !

  0 · Share on FacebookShare on Twitter
• 

  Cheryl Collins ✭✭✭✭✭✭

  10/14/21

  No problem Christophe, glad it worked.😊

  0 · Share on FacebookShare on Twitter

Sign in

Try Smartsheet

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list