How to calculate age at a certain date, not Today

Danielle Johnston · 10/13/21

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 · 10/14/21

Just divide the result on 365 the formula will be:

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

Bassam Khalil · 10/13/21

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 · 10/13/21

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 · 10/14/21

Just divide the result on 365 the formula will be:

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

Danielle Johnston · 10/14/21

Thank you so much Bassam!

Works perfectly, very helpful!

Bassam Khalil · 10/17/21

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

Best Answer