How to calculate age at a certain date, not Today

Hello,

I would like to calculate a persons age at the time of their admission into a service.

I am familiar with calculating a persons age based on todays date.


Any help, much appreciated.

Cheers,

Best Answer

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    edited 10/14/21 Answer ✓

    @Danielle Johnston

    Just divide the result on 365 the formula will be:

    persons age = ROUND(([Admission Date]@row - [Birthday Date]@row) / 365, 0)
    

    PMP Certified

    bassam.khalil2009@gmail.com

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!