Calculate AGE in Excel from Date of Birth (in Years, Months, & Days)

In this video, I will show you how to calculate age in Excel in Years, Months, and Days (when you have the date of Birth).

This can easily be done using the DATEDIF function, which is a legacy function and is made available for compatibility reasons with LOTUS 123.

With Datedif you can calculate:
-- Total years that have passed in between the date of birth and current date
-- Total number of months that have passed in between the date of birth and current date
-- Total number of days that have passed in between the date of birth and current date

⚙️ Gear I Recommend:

Note: Some of these links here are affiliate links!

#Excel #ExcelTips #ExcelTutorial

[nsraju]

You are really exploring all of the hidden /neglected functions in excel. It will make the project monitoring much attractive with automatic duration in years, months and days. Very helpful.

[shriidharkulkarni]

Excellent. Your voice and way of explaining is very friendly. I wish people like you were around when I was a little younger and not in my sixties.

[devengileo]

brilliant ! thank you for the education

[krishnaswamyhonnudikem]

It is a video which explains things very clearly and simply.

[exas]

This explanation is clearer than that on the Excel support web page.

[shazianoreen]

Thank you very much Sir.
You have Explained formulas very
well .

[wayneedmondson]

Hi Sumit.. thanks for the lesson on using the compatibility function DATEDIF. It is a great little function and very helpful in certain situations. Thanks for sharing it. Thumbs up!

[hnmsmultivideos]

Well explained, I got what I wanted. Many thanks.

[anoop]

Good explanation but u can explain in brief like what format we use and system date are also same in this

[amgadaness]

Simply explained but clearly understood 👍

[sobhienani]

This formula gives days in negative if the second date the first day of the third month of any year 1/3/2021 for example. any one can help

[oodoodoopoopoo]

Thank you. This was helpful.
(Unfortunate channel name though, imo)

[sushilpandey]

beautifully explained. Thanks for clearing my doubts on YM and MD .

[Toji]

how to click the end date with red highlighted word?

[abdulhaseeb]

Nice video and it's not datedif. Its actually date dif ( dif for difference)

[BIprofessional]

plz let me know how to applied the same formula in DAX Power BI

[christinebecken]

Isn't it easier to use: =INT(YEARFRAC(birthdate, TODAY())) ?

[faizanshabir]

month and Days function is Not working

[sree]

Hello sir, dated if is not showing in ms excel2007

[vijaykishan]

I am not getting in 2016 version. Please tell me.