Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. Step 2:Press the Enter key. How to Calculate Age in Excel (In Easy Steps) Calculate Age To calculate the age of a person in Excel, use DATEDIF and TODAY. Whether the answer is correct depends upon the methodology used to calculate the age. You can now see the calculated age in months. The result is 17. 3. 3. We can use the DATEDIF function when we need to calculate the difference between two dates. ExcelDemy is a place where you can learn Excel, and get solutions to your Excel & Excel VBA-related problems, Data Analysis with Excel, etc. Step 7: Press the Enter key. This conventional age computation may also be done in Excel. Here, the C5 is the starting cell of the Birthday column. We will get the above output shown in Column C. [Note: The results are as per the specified units, w.r.t days, months, years, etc. Step 2:After entering the formulas in their respective cells, press the Enter key. We will get the output as shown above i.e., the number of months between the start and end dates. NOTE: If you want to calculate the age at a specific date, replace the TODAY () function with . Calculate age in accumulated years, months, and days . Similarly, the B2 cell assigned the following formula: The following example displays the months along with years from DOB.