Find the most recent date

10/14/21
Accepted

Hello everyone,

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

Thank you very much


Best Answer

  • Cheryl CollinsCheryl Collins ✭✭✭✭✭
    Accepted 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

Answers

  • Cheryl CollinsCheryl Collins ✭✭✭✭✭
    Accepted 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

  • Thank you very much for your help Cheryl.

    It's so simple, really !

  • Cheryl CollinsCheryl Collins ✭✭✭✭✭

    No problem Christophe, glad it worked.😊

Sign In or Register to comment.