# How to calculate age at a certain date, not Today

Options

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,

• ✭✭✭✭✭✭
Options

Just divide the result on 365 the formula will be:

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

bassam.khalil2009@gmail.com

• ✭✭✭✭✭✭
Options

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
```

bassam.khalil2009@gmail.com

• Options

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,

• ✭✭✭✭✭✭
Options

Just divide the result on 365 the formula will be:

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

bassam.khalil2009@gmail.com

• Options

Thank you so much Bassam!

• ✭✭✭✭✭✭
Options