Руководство Excel

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.

Сделать с помощью ИИ

Пошагово

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")

Советы

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.

Вопросы и ответы

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.