How to calculate age in Excel (as of today or on a specific date 📆)

Want to know how old someone is, given their date of birth in a cell? You can use Excel's date functions to do just that.

In this video, learn how to use TODAY, DATEDIF, EDATE functions to calculate age from a date in Excel.

Sample File 📗👉
==============

It has a special surprise for you.

More on Excel Date & Time calculations ⏱
===================================
Watch these videos to learn more about Excel date functionality.

Video topics:
==========
0:00 - Calculating the age in Excel
1:20 - Using the hidden DATEDIF formula
2:12 - Age as of a specific date
2:50 - Time to reach a age milestone (60 years)
3:58 - Calculating Employee's 5th anniversary with formulas

~
Have a beautiful day 🌻🌞😀
#Excel #Formulas

[wayneedmondson]

Great one Chandoo! Also, you can use YEARFRAC() which has the optional [basis] argument with 5 choices for the calculation convention. Thanks for the tips :)) Thumbs up!!

[perka]

Thank you so much for the extra formula that helped me with my celebration dates, is a lot easier for me now to publish the members that we celebrate this year month by month. It would be great to get them in a table in a monthly order but that on another level. I don't think I have the knowledge to create the formula but this extra formula still did the trick for me. Thanks a lot!!

[vijayarjunwadkar]

Thank you Chandoo! You always bring out valuable tips and tricks, that help us solve many practical problems and it's a pleasure to watch these videos with some fun and humor built-in!😊👍

[sandeeplade]

I always follow you and use your tricks for saving my time and increase my work productivity.

Sir, i am searching for pivot table default value setting as COUNT but unable to get information to do it on net. Request for guidance.

[ExcelExpertBangladesh]

Excel expert bangladesh always like your video

[m_mike]

Chandoo, pls why do you subtract today() from the calculation of age to in 60...?

[greglapura]

but what if the other way around. the age is given and how to determine the birthdate

[lilianezeli]

You can also use Year() function. For example =YEAR(TODAY())-YEAR(A2)

where cell A2 in this context contains the date of birth, then change the format to number.

Edit: Im using excel 365 though

[vinodchowdary]

Really helpful thanks for the video..

[hassanadelsobh]

i have a question if the month is feb the days are not accurate is there a workarround

[canirmalchoudhary]

Yes it is cool and now all such calculations can be done by PQ too

[poyomanman]

I'm coming across an issue where my result for example is 11/09/2022. MY DOB column is formatted 10/29/1968. How can I convert my new age column to years as it is outputting a date? I've tried formatting the cell but I've had no success.

[satyandrasharma]

Sir... can we do code for auto left mouse click in every x min or sec by vba...if yes then please let us know....you are doing great job🙏

[chaitanyakumar]

Hi Chandoo.. How can we calculate age removing Sat and Sundays. Also if any Holidays we have.. please help me by replying

[sawaimalhi]

very nice how to become like you sir???

[Luthus]

The problem with Datedif() is that is imprecise. Specifically anticipating the age depending of the date.

[jeremiahglover]

Hi Chandoo, love your videos! Is there a way to calculate time to/from a date in a calendar format, like years, months, weeks, days? When dividing the remainders I've had trouble with months since they have irregular numbers of weeks and days.

[irfanabbassi]

Dax Fiscal Quarter is a mess..

Please make a video on it Please

[smmshoe]

I kinda differ on the age in 60., I would have used date (day, month, year+60) and then reduce the orignial date. since every 4 years is a leap year and every 400 years there is a leap hundred years. nonetheless great video as always bro, I like ur channel the most

How to ignore a black cell while using datedif formula