Calculate Age From Date of Birth: 3 Easy Methods

Whether you're filling in a form, checking eligibility, or just curious, the most common age question is: given a date of birth, exactly how old is this person today? This guide shows you how to calculate age from a date of birth three reliable ways — an instant online tool, a clear manual method, and a spreadsheet formula — with worked examples for each.

It's written for beginners, parents, students and professionals who want a dependable answer, not a rough guess.

Key Concepts: From DOB to Exact Age

Calculating age from a date of birth means measuring the time from that date to an end date (usually today). The result is best expressed as completed years, plus the remaining months and days. Getting it exact means respecting two calendar realities: months vary in length, and leap years add 29 February.

In short: To calculate age from a date of birth, find the completed years to the end date, then the leftover months and days, accounting for leap years and real month lengths.

Step-by-Step: Three Methods

Method 1 — Online Age Calculator (fastest)

1. Open the Age Calculator.
2. Enter the date of birth.
3. Set the end date to today or any "as of" date.
4. Read the exact age in years, months and days.

Method 2 — Manual calculation

Use borrow-and-carry subtraction (full logic in How Age Is Calculated):

1. Years = end year − birth year.
2. Months = end month − birth month (borrow a year if negative).
3. Days = end day − birth day (borrow a month if negative).

Example — DOB 02 March 2010, today 10 June 2026: 16 years, 3 months, 8 days.

Method 3 — Spreadsheet (Excel / Google Sheets)

Years:  =DATEDIF(A2, TODAY(), "Y")
Months: =DATEDIF(A2, TODAY(), "YM")
Days:   =DATEDIF(A2, TODAY(), "MD")

Put the date of birth in A2; DATEDIF handles leap years automatically.

Try Our Free Age Calculator

The quickest, most reliable route is our free Age Calculator — enter a date of birth and get the exact age instantly.

• ✅ Exact years, months & days from any DOB
• ✅ "Age as of" any date
• ✅ Total days, weeks and months
• ✅ Free, instant, private

👉 Calculate age from DOB now →

Real-World Examples

Example 1 — Filling in a form

A form asks for current age. DOB 15 July 1990 → the calculator returns the exact years-months-days as of today, avoiding the "did my birthday pass yet?" error.

Example 2 — A child's age

For a paediatric record, DOB 20 January 2024 → age expressed in months and days, the unit that matters for the very young.

Example 3 — Age on a future date

To know how old someone will be at an event, set the end date to the event date — handy for planning eligibility (see school admission).

Common Mistakes to Avoid

1. Year minus year only. It ignores whether the birthday has passed.
2. Assuming 30-day months.
3. Ignoring leap years.
4. Confusing DD/MM with MM/DD.
5. Using today when a fixed date is required.

Best Practices

• Enter the DOB in an unambiguous format (YYYY-MM-DD).
• Choose the correct end date — today vs a fixed cut-off.
• Cross-check with a calculator for important decisions.
• Express young ages in months/days where appropriate.

Frequently Asked Questions

How do I calculate age from a date of birth?

Measure the completed years from the birth date to the end date, then add the remaining months and days, adjusting for leap years and month lengths. A calculator or the DATEDIF formula does this automatically.

What is the DATEDIF formula for age?

Use =DATEDIF(dob, TODAY(), "Y") for years, "YM" for the extra months and "MD" for the extra days, with the date of birth in the referenced cell.

How do I calculate age as of a specific date?

Use that date as the end date instead of today. Online calculators let you set a custom "as of" date.

Can I calculate age from a birth date in the future?

If the birth date is after the end date the age is zero or negative, which usually means the dates are entered the wrong way round.

What format should I enter the date of birth in?

Use a clear format such as YYYY-MM-DD to avoid confusion between day and month, especially when sharing the result.

Conclusion

Calculating age from a date of birth is straightforward once you pick a method and respect the calendar: use the tool for speed, the manual borrow-and-carry to understand it, or DATEDIF in a spreadsheet for bulk work. All three give the same exact answer when done right.

👉 Calculate age from a date of birth →

Related Resources

• Age Calculator: Complete Guide — the full how-to
• How Age Is Calculated — the method explained
• Age Calculator for School Admission — eligibility cut-offs
• Retirement Age Calculation Guide — age to a future date