How to Calculate Age in Years, Months and Days

By 2 min read

To calculate age, subtract the birth year from the current year, then take away one if the birthday has not happened yet this year. For an exact age, count the full months since the last birthday and then the days since the last month mark. Someone born on 15 May 1990 is 36 years, 6 months and 3 days old on 18 November 2026.

Age in whole years

  1. Subtract the birth year from this year: 2026 − 1990 = 36.
  2. Has the birthday passed this year? 15 May is before 18 November, so yes.
  3. Age = 36.

If the date were 1 April 2026, the birthday would not have passed yet, so the age would be 35.

Exact age in years, months and days

  1. Find the most recent birthday: 15 May 2026.
  2. Count full months since then: 15 May to 15 November is 6 months.
  3. Count the remaining days: 15 to 18 November is 3 days.

Result: 36 years, 6 months and 3 days. The age calculator does this from a date of birth.

Age in total days

Sometimes you need the age in days, for example for a baby's milestones. The date difference calculator counts the days between the birth date and today.

Leap day birthdays

People born on 29 February have a real birthday only in leap years. In other years, legal systems treat either 28 February or 1 March as the birthday for age purposes, depending on the country, so check the rule where you live if the exact day matters. The 2000 leap day was a Tuesday, which the day of the week finder confirms for any date.

Spreadsheet formulas

  • Excel and Google Sheets: =DATEDIF(A1, TODAY(), "Y") gives completed years.
  • =DATEDIF(A1, TODAY(), "YM") gives the months after the last birthday.
  • =DATEDIF(A1, TODAY(), "MD") gives the days after the last month mark.

Avoid dividing the number of days by 365. Leap years make this drift, and the result can be a day off around birthdays.

Ages in different cultures

Some places have used other systems. In the traditional East Asian count, a baby is one year old at birth and everyone gains a year at the New Year. Most official documents use the international method described above.

Questions and answers

How do I calculate age from a date of birth?

Subtract the birth year from the current year, and take away one if the birthday has not happened yet this year.

Why not divide days by 365 to get age?

Leap years add a day every four years, so dividing by 365 slowly drifts and can be wrong around birthdays.

More from the blog