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

[@nsraju1386]

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.

[@trumpexcel]

Thanks for commenting.. Glad you found the video useful!

[@shriidharkulkarni6648]

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.

[@trumpexcel]

Thanks for the kind words... Glad you found the video useful!

[@devengileo]

brilliant ! thank you for the education

[@shazianoreen9094]

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

[@krishnaswamyhonnudikem8484]

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

[@wayneedmondson1065]

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!

[@trumpexcel]

Thanks for commenting Wayne.. Glad you found the video useful :)

[@exas4791]

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

[@hnmsmultivideos6044]

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

[@oodoodoopoopoo]

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

[@anoop613]

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

[@kirteshkhant6720]

Thankyou So Much Sir Very Helpful

[@amgadaness5761]

Simply explained but clearly understood 👍

[@sushilpandey5964]

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

[@abdulhaseeb8027]

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

[@trumpexcel]

Thanks for commenting Abdul.. and thanks for sharing... I didn't know this!

[@Up4Excel]

Makes total sense when you explain that.

[@prakashjagtap]

Thank you. This was helpful.

[@sushreesonalikabehera7132]

Thank you so much sir 🙏🙏🥰

[@sbeku]

Excellent god bless you

[@trumpexcel]

Thanks for commenting... Glad you found the video useful!

[@kellysamakabadi7311]

Thank you 🙏🏾

[@sobhienani1146]

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

[@jackwilson2304]

Thank you.

[@cristinasosa9826]

THANKYOU!

[@pastorcenterforpoliticspub3307]

Thank you!!

[@starlingsuting4858]

Amazing 👏sir

[@abdulqadirkhattak2381]

Awesome Sir

[@trumpexcel]

Thanks for commenting Abdul... Glad you found the video useful!

[@hemantakumardas7574]

Useful

[@princejag]

DIVINE.

[@trumpexcel]

Thanks for commenting Jagadeesh... Glad you found the video useful!

[@amruthaa8332]

Super

[@gopikrishna1879]

Excellent

[@qayyom]

Awesome 👍

[@trumpexcel]

Thanks for commenting Abu... Glad you found the video useful!

[@venkym8159]

Superb bro

[@trumpexcel]

Thanks for commenting Venky... Glad you found the video useful!

[@christinebecken1660]

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

[@vikasb3936]

Great

[@BIprofessional80]

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

[@dmuralidhar4680]

Sir happy Diwali thank you for the video Sir

[@trumpexcel]

Thanks for commenting... Happy Diwali to you and your loved ones :)

[@dildar.h9185]

Nice video

[@Toji69696]

how to click the end date with red highlighted word?

[@zameerbasha9519]

not working in excel 2016
why

[@faizanshabir007]

month and Days function is Not working now.....

[@oliviapena8028]

Datedif is not available now :( Office 360

[@trumpexcel]

Just checked, and DATEDIF is working on my O365 Excel. The function doesn't show up when you type the in the cell, but if you add all the arguments, it should work

[@michaelwoodruff5792]

It's not dated if, it's date dif as in the difference between the dates

[@trumpexcel]

Yeah, I learnt that after creating this video :)

[@malcolmgoodwin2135]

Is it possible to use dateif function to calculate date when age 60 is reached and how many years/m/d are left until then?

[@michaelwoodruff5792]

Same thing, just use the today() function as the start date and the date you turn 60 as the end date

[@sree9355]

Hello sir, dated if is not showing in ms excel2007

[@vijaykishan8649]

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

[@shabeelaboobacker352]

Why don’t you use all in single formula.

[@irshadbaruah7961]

how to calculate the birth year if age is known

[@vijeshsir8139]

Formula not working I'm my laptop... Guide plz

[@freddyfosso8967]

Why is it not working for me??? I'm using EXCEL 2013...

[@user-up8zd3fo8r]

not work in excel 2010

[@akhileshgiri8044]

This doesn't work

[@ahmadalamofficial6730]

❤❤❤❤❤❤❤❤❤❤

[@garetheraubenheimer2686]

I am afraid it gives a #value each time I hit ENTER key

[@koreanlifestyle9368]

Super