How to Calculate the Age in MS Excel

Quick summary

This tutorial shows how to calculate age in Microsoft Excel using the combined TRUNC and YEARFRAC formula. By referencing a birthdate cell and the TODAY function, Excel automatically returns the current age in whole years.

Steps

1. Inside your Microsoft Excel worksheet, select a cell and type an Equals (=) sign to begin the formula.
2. Type TRUNC and select it from the suggested results to add the TRUNC function.
3. Add the YEARFRAC function by typing Yearfrac and choosing it from the recommended matches.
4. Select the cell containing the birthdate data and insert a comma (,) to separate the arguments.
5. Type TODAY and select it from the suggested results, then close the first part of the formula with a closing parenthesis.
6. Insert a comma (,) and select 1 Actual/Actual from the available options to set the day-count basis.
7. Add two closing parentheses and press the Enter key to process and display the calculated age.
8. The age will now be calculated and displayed based on the selected birthdate data in your Excel worksheet.