How to calculate age at a certain date, not Today



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.


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

    ☑️ 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"


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!