To calculate age from date of birth in Excel, you must use one of the two formulas below
=(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 done if you have a set of data containing the Date of Birth. Excel has two simple ways to do it.
How to calculate age in Excel using subtraction
Here is some sample data for the first formula (calculation was done on 2019-10-08, that is the value of TODAY())
How to calculate age in Excel using DATEDIF
If you’re asking yourself what is the formula for calculating age in Excel, here is how you do it.
(calculation was done on 2019-10-08, that is the value of TODAY())
