It is very easy to calculate the age in MS Excel. Here’s a quick guide on how to do it in simple steps:
- Inside your Microsoft Excel worksheet, select a cell and then type an 'Equals' (=) sign.
- Following that, type 'Trunc' and then select it from the suggested results.
- Add the Yearfrac function next. Simply input 'Yearfrac' and choose it from the recommended matches.
- After that, select the cell that contains the birthdate data and then insert a 'Comma' (,).
- Type 'Today' and select it from the suggested results. End the first part of the formula with a closing parenthesis.
- Proceed further by inserting a 'Comma' (,) and selecting '1 Actual/Actual' from the given options.
- Once done, add two closing parentheses and then hit the 'Enter' or 'Return' key to finally process the results.
- After completing these steps, the age will be calculated based on the selected data in your Microsoft Excel worksheet.
