How to calculate age on a particular date | Excel forum

Hi Angela

Easiest way to calculate age from someone's date of birth is

- calculate the number of days old they are by subtracting from today's date.
- then divide by 365.25 to get years old.
- the answer had many decimal places so can use the INT function to give a whole number of years.

Here is the formula typed into B2 for my own DOB typed in in A2

Date of Birth Age
26/12/56 =INT((TODAY()-A2)/365.25)

Should say 54

This is accurate to one or two days which is usually acceptable. There is a more accurate but complicated formula as well I can send if you need it.

Regards
Doug