Calculate age from a date of birth to a selected date, with matching Excel formulas.
Select the date of birth.
Select the date to calculate age on.
Age
—
=DATEDIF(A1,B1,"y") & " years, " & DATEDIF(A1,B1,"ym") & " months, " & DATEDIF(A1,B1,"md") & " days"
Complete Years
—
=DATEDIF(A1,B1,"y")
Total Complete Months
—
=DATEDIF(A1,B1,"m")
Total Days
—
=B1-A1
Next Birthday
—
Calendar calculation
The calculation uses calendar dates. The selected calculation date must be the same as or later than the date of birth.