How to calculate age at a certain date, not Today

Danielle Johnston

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,

Bassam Khalil

@Danielle Johnston

Just divide the result on 365 the formula will be:

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

Bassam Khalil

Hi @Danielle Johnston 

Hope you are fine, please try to create 2 columns ( [Birthday Date] & [Admission Date]) both are date type columns. then use the following formula:

persons age at the time of their admission = [Admission Date]@row - [Birthday Date]@row

Danielle Johnston

https://community.smartsheet.com/discussion/comment/307679#Comment_307679

Hello Bassam,

Thank you for your response, this will give me a number in days. Is there a way to show this in years?

Cheers,

Bassam Khalil

@Danielle Johnston

Just divide the result on 365 the formula will be:

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

Danielle Johnston

https://community.smartsheet.com/discussion/comment/307802#Comment_307802

Thank you so much Bassam!

Works perfectly, very helpful!

Bassam Khalil

@Danielle Johnston 

Excellent, i will be happy to help you any time.

ai Bandits Orchard

What if I need an exact age. How do I do it without rounding? Basically I am looking at age requirements for a program and so I need to know their exact age on a specific future date. This formula is rounding therefor not giving me an exact date.