How to Calculate Age in Excel? - A Complete Beginner's Guide

In Microsoft Excel, it is possible to calculate the age of a person with the help of a set of formulas.

Let’s get started with this step-by-step guide to calculate age in Excel.

Recommended read: How to calculate the square root in Excel?

Steps to calculate age in Excel with the DATEDIF() function

Age calculation is done with the help of the DATEDIF formula in Excel that requires the date of birth and today’s date to be available in the sheet.

This is how Excel can provide you the calculated ages of people-

So, let’s learn to calculate the current age of a person-

Prepare a database with names of people in one column and their DOB (date of birth) in the adjacent column.
Now, create a new column called TODAY and enter today’s date formula instead of manually typing today’s date.
Type =TODAY() and press ENTER to get today’s date. This will automatically change the date every day to the current date on your system, without you having to manually set the current date every day.

This is how your database should look like so far-

Calculating age in years in Excel

Let’s begin calculating their ages in years with =DATEDIF formula-

Add 5 new columns to the table named- YEAR, MONTH, DAYS, DAY, and Age in Words (optional).
To calculate age in years, select a cell under the YEAR column of a person.
Type =DATEDIF( and select the cell under the DOB column for the person you want to calculate the date, then
Add a comma and select the cell with today’s date, then
Finally, add a comma and type “Y”
Press ENTER.

You can now see the calculated age in years.

You can simply drag down or double-click on the lower right corner of this cell to automatically calculate age in years for other people in the database.

Calculating age in months in Excel

Let’s begin calculating ages in months with =DATEDIF formula-

Select a cell under MONTH column.
Add 5 new columns to the table named- YEAR, MONTH, DAYS, DAY, and Age in Words (optional).
To calculate age in years, select a cell under the YEAR column of a person.
Type =DATEDIF( and select the cell under the DOB column for the person you want to calculate the date, then
Add a comma and select the cell with today’s date, then
Finally, add a comma and type “YM”
Press ENTER.

You can now see the calculated age in months.

Calculating age in days in Excel

Let’s begin calculating ages in days with =DATEDIF formula-

Select a cell under DAYS column.
To calculate age in years, select a cell under the YEAR column of a person.
Type =DATEDIF( and select the cell under the DOB column for the person you want to calculate the date, then
Add a comma and select the cell with today’s date, then
Finally, add a comma and type “MD”
Press ENTER.
You can now drag down or double-click on the lower right corner of this cell to automatically calculate age in years for other people in the database.

You can now see the calculated age in days.

Calculating weekday of birth

Let’s begin finding the day of the week when the person was born with =CHOOSE formula-

Select a cell under DAY column.
Type =CHOOSE( and then type WEEKDAY
Then, select the DOB of a person and close the bracket but don’t press ENTER yet!
Put a comma and type “Sun”,”Mon”,”Tues”,”Wed”,”Thurs”,”Fri”,”Sat” without spaces.

Look at the example below to understand better.

Close the bracket again and press ENTER.
You now have a day of birth for a person.
Double-click on the lower right corner of this cell to automatically calculate weekday of birth for other people in the database.

You can now see the calculated days of birth.

Expressing age in words in Excel

To express the calculated age in words, you can use the CONCATENATE formula to achieve this. Here is how-

Select a cell under Age in words.
Type =CONCATENATE( then select calculated age in years.
Put a comma and type “ “ to give a space between each value that is being concatenated.
Continue to type ,”years”,” “,V30,” “,”months”,” “,W30,” “,”days”).
Press ENTER to complete the formula.

Conclusion

This article was a complete beginner’s guide on calculating age of people in Microsoft Excel. Follow this tutorial carefully and learn how to correctly calculate age in Excel. If you have any doubts regarding age calculation, feel free to drop a comment and we will help you out!