Subtracting birth year from the current year gives the wrong answer for half the year – it ignores whether the birthday has happened yet. For forms, insurance, school admissions or visa applications you often need the exact age in years, months and days. Here is how to calculate it correctly.
Page Contents
The simple method (years only)
- Subtract the birth year from the current year.
- If this year’s birthday has not happened yet, subtract 1.
Example: born 20 September 1990, today 17 March 2026. 2026 − 1990 = 36, but the birthday is still to come, so the age is 35.
Years, months and days
- Years: as above.
- Months: count the full months since the last birthday.
- Days: count the days since that month date.
Born 20 September 1990, on 17 March 2026: last birthday 20 September 2025, then 5 full months to 20 February 2026, then 25 days to 17 March. Age: 35 years, 5 months, 25 days.
Months have different lengths, so manual calculations are easy to get wrong – the Age Calculator handles this automatically.
Leap-year birthdays (29 February)
In non-leap years, people born on 29 February legally reach their next age on either 28 February or 1 March, depending on the country. For example, the UK uses 1 March for some legal purposes, while many systems use 28 February. Check the rule for the purpose you need.
Formulas for Excel and Google Sheets
| Result | Formula (birth date in A2) |
|---|---|
| Age in years | =DATEDIF(A2, TODAY(), “Y”) |
| Months after last birthday | =DATEDIF(A2, TODAY(), “YM”) |
| Days after last month date | =DATEDIF(A2, TODAY(), “MD”) |
| Total days lived | =TODAY() – A2 |
Note: Microsoft warns that the “MD” option can return wrong results in some cases, so double-check edge cases.
Common uses
- Checking eligibility (school entry, retirement, licences)
- Insurance and pension forms
- Age on a specific date, such as an exam or travel date
- Fun facts: total days, weeks or hours lived
Age in different cultures
Some cultures traditionally counted age differently – for example, the traditional Korean age system counted a baby as one year old at birth. South Korea officially adopted the international system for legal purposes in 2023.
FAQ
How do I calculate my exact age?
Count full years since your last birthday, then months and days since then – or use an age calculator.
How many days old am I?
Subtract your date of birth from today’s date. The calculator shows it instantly.
How do you calculate age on a specific date?
Use that date instead of today in the same calculation.
When does someone born on 29 February have a birthday?
On 28 February or 1 March in non-leap years, depending on the country and purpose.
Is my birth date stored?
No. The calculator runs entirely in your browser.
Need a website or app for your business? Talk to Techpass Master – we design and build websites and apps for clients worldwide.
