📘 Excel Formula to Calculate Age

Complete guide to Excel formulas for calculating age from date of birth. Step-by-step instructions with examples.

📊 DATEDIF | YEARFRAC | Simple Formula

🔢 Free Online Age Calculator

Test your age before applying Excel formulas!

🟢 LIVE CURRENT TIME
--
--:--:--
--
📘 EXCEL AGE CALCULATOR
YEARS
0
MONTHS
0
DAYS
0
🏠 Back to Home
🎂 Age Calculator Tools
⚡ All age, birthday & date-of-birth calculators in one place!
🎯 Total 31 Age Calculator Tools
🔘 All 📅 Basic 👫 Difference 🧬 Special 📊 Excel

📘 Excel Formulas to Calculate Age

Here are the most common Excel formulas to calculate age from date of birth with examples.

📌 Method 1: DATEDIF Function (Most Accurate)

The DATEDIF function calculates the difference between two dates in years, months, or days.

=DATEDIF(A1, TODAY(), "Y") & " Years, " & DATEDIF(A1, TODAY(), "YM") & " Months, " & DATEDIF(A1, TODAY(), "MD") & " Days"

Where A1 is the cell containing the date of birth.

📅 Example 1: Years Only
=DATEDIF(A1, TODAY(), "Y")
Result: 25 (if born 25 years ago)
📅 Example 2: Months Only
=DATEDIF(A1, TODAY(), "YM")
Result: 6 (if 6 months since last birthday)
📅 Example 3: Days Only
=DATEDIF(A1, TODAY(), "MD")
Result: 15 (if 15 days since last birthday)
📅 Example 4: Full Age
=DATEDIF(A1, TODAY(), "Y") & "Y " & DATEDIF(A1, TODAY(), "YM") & "M " & DATEDIF(A1, TODAY(), "MD") & "D"
Result: 25Y 6M 15D

📌 Method 2: YEARFRAC Function

Returns the age as a decimal number (e.g., 25.5 years).

=INT(YEARFRAC(A1, TODAY()))

This returns the age in whole years.

📅 Example 1: Whole Years
=INT(YEARFRAC(A1, TODAY()))
Result: 25 (if born 25.5 years ago)
📅 Example 2: Decimal Years
=YEARFRAC(A1, TODAY())
Result: 25.5 (if born 25.5 years ago)

📌 Method 3: Simple Formula (Quick Estimate)

Divide total days by 365.25 to account for leap years.

=(TODAY() - A1) / 365.25

This is less accurate than DATEDIF but works for quick estimates.

📊 Quick Reference - Excel Age Formulas

Formula Description Example Result
=DATEDIF(A1,TODAY(),"Y") Years only 25
=DATEDIF(A1,TODAY(),"YM") Months only 6
=DATEDIF(A1,TODAY(),"MD") Days only 15
=INT(YEARFRAC(A1,TODAY())) Whole years 25
=(TODAY()-A1)/365.25 Decimal years 25.5

🔗 Related Age Calculators

📅 Chronological Age 📊 Excel Age Guide 🌐 Online Age 📸 Age by Photo 🧬 Biological Age

❓ Frequently Asked Questions

🔹 What is the best Excel formula to calculate age? +
The DATEDIF function is the most accurate: =DATEDIF(A1, TODAY(), "Y") for years, "YM" for months, and "MD" for days.
🔹 How do I calculate age in years only in Excel? +
Use: =DATEDIF(A1, TODAY(), "Y") or =INT(YEARFRAC(A1, TODAY()))
🔹 Does Excel DATEDIF work on all versions? +
Yes, DATEDIF works in Excel 2007, 2010, 2013, 2016, 2019, 2021, and Office 365.
🔹 How do I calculate age on a specific date in Excel? +
Replace TODAY() with a specific date: =DATEDIF(A1, DATE(2026,12,31), "Y")
🔹 Is this age formula guide free? +
Yes! Our Excel formula guide and age calculator are 100% free.