Calculate age from a date of birth
Choose a birth date and the date on which to calculate age. The result separates complete years, remaining months, remaining days and total days. You can use a past or future calculation date, provided it is not before the date of birth.
Formula and calculation method
Age is calculated in complete years, months, and remaining days. Monthly anniversaries beyond the last day of a month use that last day. February 29 anniversaries use February 28 in non-leap years.
Worked example
From 1 January 2000 to 3 February 2026, the calendar age is 26 years, 1 month and 2 days.
How are February 29 birthdays handled?
A February 29 anniversary is clamped to February 28 in a non-leap year. Monthly anniversaries beyond the end of a month use that month’s last day.