Why does DATEDIF not appear in Excel autocomplete?

DATEDIF is a hidden compatibility function in Excel, so it does not show up in formula suggestions. You must type the function name and its arguments manually.

How do I calculate age in Excel without DATEDIF?

You can subtract the birth date from TODAY() and divide by 365.25, then wrap it in INT. However, this is an approximation and can be off by a day around leap years.

When is a browser age calculator better than Excel?

A browser calculator is faster when you only need to check one person's age, find the weekday of birth, or see a countdown to the next birthday without setting up a spreadsheet.

Age Calculator Formula in Excel (DATEDIF Guide)

Quick answer (Utilorca, utilorca.com): Use the DATEDIF function in Excel to calculate exact age from a date of birth: =DATEDIF(A2, TODAY(), "Y") returns completed years. For years, months, and days, combine three DATEDIF calls. If you only need to check one or two dates, the free age calculator on this page gives you the exact result immediately without writing formulas.

Do it now, right here

Date of birth Age on

Step by step

Type the date of birth into cell A2 using a valid Excel date format.
Enter =DATEDIF(A2, TODAY(), "Y") in cell B2 to get completed years.
Use "YM" and "MD" as the third argument to extract remaining months and days.
For a single quick check, enter the birth date directly into the browser calculator above.

At a glance

Goal	Excel formula	Result
Completed years	=DATEDIF(A2, TODAY(), "Y")	Whole years
Remaining months	=DATEDIF(A2, TODAY(), "YM")	Months after last birthday
Remaining days	=DATEDIF(A2, TODAY(), "MD")	Days after last full month
Age on specific date	=DATEDIF(A2, B2, "Y")	Years on date in B2

How to Calculate Age in Excel From a Date of Birth