How to Calculate Age from Date of Birth (Years, Months, Days)

🎂Free Age Calculator
Exact age in years, months and days – and days until your next birthday.Open tool →

The method

Subtract the birth year from the current year, then take one off if the birthday hasn't happened yet this year. For months and days, count forward from the last birthday.

Instantly

Enter the date of birth in the Age Calculator – it shows exact years, months and days, total days and weeks, and the countdown to the next birthday. Change 'age at' to calculate age on a past or future date (like a school cut-off date).

In Excel or Google Sheets

=DATEDIF(A1, TODAY(), "Y") gives full years. Use "YM" for remaining months and "MD" for remaining days.

Leap-year birthdays

People born on 29 February usually count their birthday on 28 February or 1 March in non-leap years, depending on the country and the purpose.

Frequently asked questions

How do I calculate age on a specific date?

Set the 'age at' date in the calculator.

Does it count leap years?

Yes, it uses the real calendar.

Can I find the days between any two dates?

Yes, use it as a date difference calculator.