How to Calculate Age from Date of Birth in Excel

To calculate age based on a birth date in Excel, the DATEDIF function is the most efficient method. By setting the start_date to your cell containing the date of birth (e.g., A2), the end_date to TODAY(), and the unit to "Y", Excel automatically calculates the number of full years between those two dates.

This formula is dynamic, meaning it will update automatically every time you open your spreadsheet. It is perfect for HR records, member databases, or any project where you need to track current age without manually updating your data every year.