To calculate the age of a person in Excel use DATEDIF and TODAY. Using Excel 2003 engage the wizard by choosing PivotTable and PivotTable Charts from the Data menu and then click Finish. Many thanks Subscribe for Weekly Excel Tips and Tricks.
Calculate age based on date of birth in years months and days.
Select the date column that you will calculate average by and click the Kutools Format Apply Date Formatting. Biological age test will estimate your bodys real age. To calculate the average age of death you must calculate a weighted average illustrated below. Enter the date of birth into cell A2.