How to Calculate Age From a Date of Birth
A form that asks your age usually wants a whole number, but school cut-offs, insurance quotes and pension rules can depend on the exact months and days. This article shows how to calculate age from a date of birth in five ways: an online calculator, quick mental math, a full manual method, the DATEDIF formula in Google Sheets or Excel, and age on a specific date other than today. It also explains how February 29 birthdays are handled.
What Does “Exact Age” Mean?
Exact age is the full difference between a date of birth and a reference date (usually today), expressed as years, months, and days, not just years. That precision matters: someone born on 10 January 1995 is 31 years, 9 months, and 7 days old on 17 October 2026, and school cut-offs, legal thresholds, and insurance premiums can hinge on those months and days.
How to Calculate Age: 5 Methods
Method 1: Use an Online Age Calculator (Fastest)
Enter any date of birth into the free age calculator and get the exact age straight away: years, months, days, plus totals in weeks and days lived. It handles leap years and varying month lengths automatically, which removes the risk of arithmetic slips.
Method 2: Quick Mental Math
For a fast estimate in your head: subtract the birth year from the current year, then subtract 1 if the birthday hasn’t happened yet this year. Example: born in 1995, it’s October 2026 → 2026 − 1995 = 31, and the January birthday already passed → 31 years old. Takes five seconds; accurate to the year.
Method 3: Full Manual Calculation
For exact years, months, and days, work out each part in turn:
- Years: current year − birth year, minus 1 if the birthday hasn’t passed yet this year.
- Months: months since the last birthday; if today’s day-of-month is before the birth day, subtract one more month.
- Days: today’s day − birth day; if negative, borrow the days of the previous month.
Worked example: born 10 January 1995, today 17 October 2026. Years = 31 (birthday passed), months = 9 (January → October), days = 17 − 10 = 7. Result: 31 years, 9 months, 7 days.
Method 4: Google Sheets or Excel Formula
For spreadsheets, Google’s DATEDIF function does it in one cell. With the birth date in A1 and today’s date in B1:
=DATEDIF(A1,B1,"Y")→ complete years=DATEDIF(A1,B1,"YM")→ remaining months=DATEDIF(A1,B1,"MD")→ remaining days
Combine them into one readable result. For a decimal-year age (useful in finance), Google’s YEARFRAC function returns the fraction directly.
Method 5: Age on a Specific Date
Sometimes you need age on a date that isn’t today, such as a school cut-off, a competition eligibility date, or a retirement threshold. Use the same methods but replace “today” with the target date. Method 1’s calculator accepts any reference date; for manual math, just run the steps against that date instead.
Born on February 29? Here’s How It Works
Leap-day babies turn a year older on February 28 or March 1 in non-leap years (conventions vary by country and purpose). Age calculators handle this automatically by treating the birthday as the nearest valid date, which is one more reason Method 1 beats hand math for edge cases.
Where Exact Age Actually Matters
- School admissions: cut-off dates decide which year group a child enters, so months matter.
- Legal documents: many rights and contracts activate on the exact birthday.
- Insurance: premiums can change on the exact day of a birthday.
- Retirement and pensions: eligibility often depends on reaching an exact age threshold.
- Medical records: some dosages and health benchmarks depend on exact age, especially for children.

Frequently Asked Questions
How do you calculate age from date of birth?
Subtract the birth year from the current year, then subtract 1 if the birthday hasn’t occurred yet this year. For exact years, months, and days, use an online age calculator or the manual borrowing method.
How do I calculate age in months only?
Multiply complete years by 12 and add the remaining months. For example, 31 years and 9 months = (31 × 12) + 9 = 381 months. In Google Sheets: =DATEDIF(A1,B1,"M").
What is the DATEDIF formula for age?
=DATEDIF(birth_date, today, "Y") gives complete years, "YM" gives remaining months, and"MD" gives remaining days. See Google’s official DATEDIF documentation linked above.
How is age calculated for someone born on February 29?
In non-leap years, the birthday is observed on February 28 or March 1, depending on convention. Age calculators handle this automatically.
Can I calculate someone’s age on a past or future date?
Yes. Replace “today” with the target date in any method. Online calculators let you set a custom reference date; manually, just run the same steps against that date.
Why does manual age calculation go wrong?
Two culprits: months have different lengths (28 to 31 days), and leap years add a February 29 every four years. The borrowing method handles both, but a calculator does the bookkeeping for you.
Final Thoughts
Calculating age is simple in concept (it’s the difference between two dates), but the calendar’s quirks (unequal months, leap years) make hand math surprisingly error-prone. Use the quick mental method for estimates, the spreadsheet formula for bulk work, and the free calculator whenever the exact answer matters.
Try it now: calculate exact age for free. It works in your browser, and nothing you enter ever leaves your device.
Free tools for this
Everything runs in your browser. Your files never leave your device.