How to Calculate Age in Excel

by

To calculate the age of a person in Excel, use the DATEDIF function and the TODAY function. The DATEDIF function has three arguments.

1. Enter the date of birth into cell A2.

2. Enter the TODAY function into cell B2 to return today’s date.

Worked Example:   Conditional formatting date past due in Excel

3. The DATEDIF function below calculates the age of a person.

Note: fill in “y” for the third argument to get the number of complete years between the date of birth and today’s date.

4. Calculate the age of a person without displaying today’s date.

Worked Example:   Understanding Named Range, Named Constant, Name Manager in Excel Formulas

5. Calculate the age of a person on a specific date.

Note: the DATE function accepts three arguments: year, month and day.

6. Calculate the age of a person in years, months and days.

Note: fill in “ym” for the third argument to ignore years and get the number of months between two dates. Fill in “md” for the third argument to ignore months and get the number of days between two dates. Use the & operator to concatenate strings.

Worked Example:   Calculate retirement date in Excel

Leave a Reply

Your email address will not be published. Required fields are marked *