📘 Calculate Age from Date of Birth in Excel

Complete guide to calculating age from DOB in Excel. Perfect for HR, payroll, and personal use.

📊 DOB Based | Step-by-Step | Free Examples

🔢 Free Online Age Calculator

Test your age first before learning Excel!

🟣 LIVE CURRENT TIME
--
--:--:--
--
📘 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

📘 How to Calculate Age from Date of Birth in Excel

Follow these simple steps to calculate age from DOB in Excel.

📌 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.

📅 Years Only
=DATEDIF(A1, TODAY(), "Y")
Result: 25 (years)
📅 Months Only
=DATEDIF(A1, TODAY(), "YM")
Result: 6 (months)
📅 Days Only
=DATEDIF(A1, TODAY(), "MD")
Result: 15 (days)
📅 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.

📌 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

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

🔗 Related Age Calculators

📅 Chronological Age 📊 Excel Age Guide 📘 Excel Formula Guide 🌐 Online Age 🧬 Biological Age

❓ Frequently Asked Questions

🔹 How do I calculate age from date of birth in Excel? +
Use the DATEDIF function: =DATEDIF(A1, TODAY(), "Y") for years, "YM" for months, and "MD" for days.
🔹 What is the formula to calculate age from DOB in Excel? +
The most accurate formula is: =DATEDIF(A1, TODAY(), "Y") & "Y " & DATEDIF(A1, TODAY(), "YM") & "M " & DATEDIF(A1, TODAY(), "MD") & "D"
🔹 Does Excel calculate age from date of birth automatically? +
Yes, with the DATEDIF function and TODAY() for current date.
🔹 Can I calculate age on a specific date? +
Yes! Replace TODAY() with a specific date like DATE(2026,12,31).
🔹 Is this guide free? +
Yes! Our Excel DOB guide and age calculator are 100% free.