How to calculate age in Excel

To calculate a person’s age in Excel, you can use the following two formulas

=(TODAY()-DOB)/365.25
=DATEDIF(DOB,TODAY(),"Y")

where DOB is the range (cell) that has the Date of Birth value

Age calculation can be useful where you have a set of data containing Date of Birth and you want to filter the data into age groups. Excel has two simple ways to do it.

Calculate age using subtraction

Here is some sample data for the first formula (calculation was done on 2019-10-08, that is the value of TODAY())

Calculate age using DATEDIF

Here is some sample data for the second formula (calculation was done on 2019-10-08, that is the value of TODAY())