How to Calculate Exact Age from a Date of Birth (Years, Months and Days)
Working out an age in years is easy; working it out to the day — for forms, eligibility checks and leap-year birthdays — needs a few rules. Here is how exact age is calculated and where the edge cases hide.
Updated October 22, 20265 min read
Everyone knows roughly how old they are. Application forms, eligibility rules and records often need more: age in completed years on a specific date, age in months for a baby's development check, or the exact number of days for an insurance or legal calculation. And then there are the people born on 29 February, who only have a real birthday one year in four. Calculating age precisely is simple once the rules are clear.
How exact age is calculated
Age is counted in completed units. Someone born on 15 March 2000 is 25 until the end of 14 March 2026 and turns 26 on 15 March 2026. The months and days part is what has passed since the last birthday: on 20 October 2026, that person is 26 years, 7 months and 5 days old.
Enter the date of birth
Open the age calculator and enter the date of birth.
Choose the date to measure on
It defaults to today, but forms often ask for age on a specific date — 1 September for school entry, the closing date of an application, the date of an event. Set that date instead.
Read the format you need
The result is shown as years, months and days, and as totals: total months, weeks and days lived. Use whichever the form or rule asks for.
Leap-year birthdays (29 February)
Someone born on 29 February turns a year older on either 28 February or 1 March in non-leap years, and different countries' laws pick different days. The calculator lets you choose the rule, so the result matches the jurisdiction or the organisation you are dealing with. For a leap-day baby the question is not academic: it decides on which day they can legally sign a contract, drive or vote.
| Rule | Birthday in a non-leap year | Used by |
|---|---|---|
| 28 February | The last day of February | A minority of rules, and many people's own custom |
| 1 March | The day after 28 February | Almost every jurisdiction — and the calculator's default |
When in doubt, check the rule the specific authority applies. The calculator's job is to make that choice explicit instead of silently picking one.
Exact age in years, months and days, total days, weeks and months, age at any past or future date, and a choice of 29 February rule. Free for up to 25 people in a list; Pro removes the limit and adds CSV and calendar export.
Calculate exact ageAges for a whole list of people
Teachers grouping a class by age, coaches checking age categories and administrators verifying a register all need ages for many people against one reference date. Enter or paste the list and the calculator works out each person's age on that date at once. Free handles up to 25 people per list; Pro has no row limit and exports the results to CSV or a calendar of upcoming birthdays.
Because the calculation runs on your own device, a class list or a patient register never leaves your computer — once the page has loaded, it keeps working with no connection at all.
Age in months and weeks
For babies and young children, age is usually given in months or weeks: development milestones, vaccination schedules and growth charts are all organised that way. A baby born on 10 January is 3 months old on 10 April, regardless of the different month lengths in between. The total-months figure gives exactly this number without manual counting.
Calculating age in Excel
In a spreadsheet, =DATEDIF(A1, B1, "Y") gives completed years between a birth date in A1 and a reference date in B1. Use "YM" for the remaining months and "MD" for the remaining days. Avoid dividing the number of days by 365 or 365.25 — it is close but wrong around birthdays, which is exactly when an age check matters.
Time zones: the birthday that starts early
A person born at 23:30 in New York was born on the next calendar day in London. For everyday age this never matters, but for exact-to-the-hour calculations, or someone born just before midnight who now lives in another country, the time zone of the birth defines the date. The calculator can take the time and zone of birth into account, including daylight saving, when that precision is needed.
Quick checks
- Has the birthday happened yet this year? If not, the age is the year difference minus one.
- Is the reference date fixed by a rule? Use it, not today.
- Is the person born on 29 February? Choose the rule the relevant authority uses.
- Do you need months or days? Use the totals rather than multiplying years by 12 or 365.
Where exact age is checked
- School admission: most systems fix a cut-off date — a child must have turned a certain age by 1 September or a similar date — so age is measured on that day, not on the day you apply.
- Sports and competitions: age categories are usually set by age on 31 December or on a specific day of the season.
- Pensions and benefits: eligibility often begins the day a birthday is reached, and some schemes count in months as well as years.
- Insurance quotes: premiums can change at a birthday or at the nearest birthday, depending on the insurer's rule.
- Travel documents: some countries' rules for minors depend on exact age on the travel date — see the passport photo size guide for the photo side of applications.
In every one of these cases, the question is "how old on date X under rule Y", which is exactly what setting a reference date answers.
Frequently asked questions
How do I calculate my exact age from my date of birth?
Enter your date of birth in the age calculator. It shows your age in completed years, months and days, plus total months, weeks and days, measured on today's date or any date you choose.
How do I calculate age on a specific date?
Set the reference date in the calculator instead of using today. This is what eligibility rules such as 'aged 18 on 1 January' require.
When does someone born on 29 February have a birthday?
In non-leap years, either 28 February or 1 March, depending on the rule the relevant country or organisation applies. The calculator lets you choose which rule to use.
How do I calculate age in Excel?
Use =DATEDIF(birth, reference, "Y") for completed years, with "YM" and "MD" for the remaining months and days. Avoid dividing days by 365, which is wrong around birthdays.