Calculate Age from Date of Birth in Excel Automatically

Need to calculate someone’s age from their date of birth in Microsoft Excel? Whether it’s employee data, student lists, or survey records, Excel can instantly calculate age using built-in formulas—no calculator required.

This step-by-step guide shows how to calculate age automatically using Excel functions like DATEDIF, YEAR, and TODAY—accurately and dynamically across all versions of Excel.

📆 Method 1: Using the DATEDIF Function (Most Accurate)

The DATEDIF function is the most precise way to calculate age in years from a date of birth. It measures the time between two dates and returns the number of completed years.

Formula:

=DATEDIF(A2, TODAY(), "Y")

A2 — Cell containing the date of birth
TODAY() — Automatically updates the current date
"Y" — Returns the age in full years

Example:

Name	DOB	Age Formula
John	04/10/1990	=DATEDIF(B2, TODAY(), "Y")

This automatically returns the person’s age in years and updates each day.

📊 Method 2: Show Age in Years and Months

To display both years and months, use this extended formula:

=DATEDIF(A2, TODAY(), "Y") & " Years, " & DATEDIF(A2, TODAY(), "YM") & " Months"

Example output: 33 Years, 2 Months. Perfect for HR or school reports that need more detail.

🔢 Method 3: Using YEAR and TODAY Functions

This simpler formula works too:

=YEAR(TODAY()) - YEAR(A2)

⚠️ However, it can slightly overestimate the age if the birthday hasn’t occurred yet this year. For exact accuracy, always use DATEDIF.

✅ Best Practices and Tips

Always format DOB cells as Date to avoid formula errors.
Use Data Validation to prevent invalid entries.
Highlight age ranges (e.g., over 60) using Conditional Formatting.
DATEDIF is the best choice for accuracy and automatic updating.

🔄 Automatically Updates Over Time

The beauty of TODAY() is that your sheet refreshes every day. Open the file tomorrow, and the ages are instantly updated — ideal for HR databases, schools, or client records.

📘 Real-World Uses

HR departments tracking employee ages and eligibility.
Schools maintaining accurate student information.
Surveys applying age-based filters or insights.
Healthcare or insurance reports calculating age groups.

With one simple formula, Excel becomes a dynamic, error-free age calculator. Start using these formulas today to save time and improve data accuracy.

Calculate Age from Date of Birth in Excel Automatically