Enter a date of birth to get the exact age in years, months and days, along with the total months, weeks and days, and a countdown to the next birthday. Change the second date to find the age on any day, past or future.
Age in years=DATEDIF(A2,B2,”y”)
Total days=B2−A2
Works forAny two dates
Age
- Total months
- Total weeks
- Total days
- Next birthday
How to calculate age in Excel
With the date of birth in A2 and today’s date in B2 (or TODAY()), DATEDIF gives each part:
| To calculate | Excel formula |
|---|---|
| Complete years | =DATEDIF(A2,TODAY(),"y") |
| Months after the last birthday | =DATEDIF(A2,TODAY(),"ym") |
| Days after the last full month | =DATEDIF(A2,TODAY(),"md") |
| Total days alive | =TODAY()-A2 |
| Age with decimals | =YEARFRAC(A2,TODAY()) |
=DATEDIF(A2,TODAY(),"y")&" years, "&DATEDIF(A2,TODAY(),"ym")&" months, "&DATEDIF(A2,TODAY(),"md")&" days"For more ways to count the time between dates, see days between two dates.
Frequently asked questions
How is age calculated?
Count the complete years since the date of birth, then the complete months since the last birthday, then the remaining days.
What about people born on 29 February?
In years that aren’t leap years, the next birthday is shown as 1 March.
Can I find someone’s age on a past date?
Yes. Change the “Age on” date to any date after the date of birth.