Calculate age

Support

Hello,

Select a different account.

You have multiple accounts

Choose the account you want to sign in with.

Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web More...Less

Select a cell and enter =DATEDIF(A1,B1,"y") where A1 is the birthdate and B1 is the current date.
The last parameter is "d", "m", or "y" to specify a return value in days, months, or years.
Press Enter.

Tip: Use TODAY() to calculate someone's age today. Example =DATEDIF(A1,TODAY(),"Y").

Select a cell and enter =DATEDIF(A1,B1,"y") where A1 is the birthdate and B1 is the current date.
The last parameter is "d", "m", or "y" to specify a return value in days, months, or years.
Press Enter.

Tip: Use TODAY() to calculate someone's age today. Example =DATEDIF(A1,TODAY(),"Y").