How to calculate Age in Excel 2010 based on Birthday?
In Excel 2010, you can calculate the Age of a person by applying the below formula.
How to calculate Age in Excel 2010 based on Birthday?
Assume that you will enter the date of birth in the cell C1, the formula to calculate age in Microsoft Excel will be
=DATEDIF(C1,TODAY(),”Y”) & ” Years”
This will display the number of years as shown in the screenshot.
The DATEIF function takes 3 parameters
DATEDIF(StartDate,EndDate,Unit)
1. Start Date
2. End Date
3. Unit
The Unit can be “M” for months, “D” for days, “Y” for years.
