How to Calculate Age From a Date of Birth

Published 17 October 2026 · By the AI Mode Team

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:

  1. Years: current year − birth year, minus 1 if the birthday hasn’t passed yet this year.
  2. Months: months since the last birthday; if today’s day-of-month is before the birth day, subtract one more month.
  3. 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:

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

how to calculate age

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.

More Calculator Guides

Leave a Reply

Your email address will not be published. Required fields are marked *