Dates & Time

Excel formula for Calculate age from a birth date

Get a person's age in whole years from their date of birth.

Copy this formula

=DATEDIF(A2, TODAY(), "Y")

How the formula works

DATEDIF measures the difference between the birth date and today. The "Y" unit returns complete years, correctly accounting for whether this year's birthday has passed.

Examples

=DATEDIF("1990-06-23", TODAY(), "Y")→36

Age in completed years as of today.

Other ways to do this

Years and months

=DATEDIF(A2, TODAY(), "Y") & "y " & DATEDIF(A2, TODAY(), "ym") & "m"

Shows age like "36y 0m".

FAQ

Will the age update automatically?

Yes — TODAY() recalculates each day the workbook opens, so the age stays current.

Related formulas

Days between two dates Add or subtract months from a date

Functions used

DATEDIF TODAY

Need a formula for your own data?

Describe what you want in plain language and let ExcelGPT write, explain, and verify the formula — free to start, no plugin.

Try ExcelGPT free