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