Excel-Anleitung

How to Calculate Age from a Birthdate in Excel

Calculating age in Excel is simple using the DATEDIF function, which calculates the difference between two dates in years, months, or days.

Mit KI erledigen

Schritt für Schritt

1
Prepare your data
Ensure your birthdate is entered in a standard date format in a cell, for example, cell A2.
2
Enter the DATEDIF formula
Click on the cell where you want the age to appear and type the formula: =DATEDIF(A2, TODAY(), "y").
3
Press Enter
Press the Enter key to display the calculated age in years.

=DATEDIF(start_date, TODAY(), "y")

Tipps

The "y" argument in the formula tells Excel to return the number of full years between the two dates.
Ensure the cell containing the birthdate is formatted as a Date, not Text.

FAQ

Why doesn't DATEDIF appear in the Excel function list?

DATEDIF is a 'compatibility' function and is intentionally hidden from the formula autocomplete menu, but it works perfectly in all versions of Excel.