Uploaded July 2023 | Updated September 2026, 2 weeks ago

---

How To Calculate Age In Excel From A Date Of Birth? | Excel Tutorials For Beginners | Age calculating formula in Excel from Today
This video tutorial offers a step-by-step guide on how to calculate age using a date of birth in Excel. You’ll be able to find out the exact number of years that passed from date of birth until now.

How to Calculate Current Age in Full Years
Open Excel.
Click in the cell where you want the age to appear.
Type =TRUNC(YEARFRAC(Select the cell containing the date of birth,TODAY()))
Press Enter and The person’s age in years is calculated.