Calculate Age in Years, Months and Days in Excel

How to calculate age in days months and years in excel?
Calculate completed age in Excel using the DATEDIF function.
DATEDIF formula is explained in detail in this video. Watch full video to understand the concept.
Excel_Series is a comprehensive video series of Microsoft Excel tutorials. You will find basic to advanced level Excel videos here for free! Learn Tips, Tricks, Formulas, Functions and Shortcuts.
Thanks for watching this video.
Feel free to comment your questions. You can also request topics.
Connect with me on :
Twitter : / the_akshay_1
FB : / theakshay2
#Excel_Series

[@laceycook4935]

This video really helped me, thank you so much for posting this.

[@TheAkshay]

Thanks for the feedback

[@endingmaker213]

I've was struggling with this for a little while, and I just wanna say that I love you.

[@TheAkshay]

Stay tuned for more

[@ninadbhoir2878]

You r real saviour bro thanks

[@lachinkhammadov9343]

thanks for sharing and explaining.

[@TheAkshay]

Glad it was helpful!

[@pratickdas6544]

thank you sir

[@TheAkshay]

Most welcome

[@suvankaratta5873]

THANKS SIR, YOU HELPED ME

[@TheAkshay]

Good to know that

[@atul2047]

ms office 2024 mai datedif ka function nhi show kar rhaa

[@ShivaniKumari-tn4oz]

Thank you for helping 😊

[@TheAkshay]

I am glad that my video helped you.

[@karanchettri9248]

That worked , thanks.

[@TheAkshay]

🙏🏼

[@abhishekkaushik6138]

I got it but know I want to know that how to do same trick but in opposite term ... For example 18 year 3 months 24 days are given in question so how can we identify the date of birth by formula

[@ronwalters1582]

Very nice video Akshay. Keep it up. I was just curious to know if there is any way to get the years and months in one column for example; For 6 years and 6 months as just 6.5 instead of the whole thing where it says "6 years and 6 months in combined formula". That would really help if possible. Thanks in anticipation..Cheers

[@TheAkshay]

You can use following formula:
=YEARFRAC (start_date, end_date)

[@ronwalters1582]

Thank you so much for your reply. I really appreciate it. You are a star.....

[@TheAkshay]

You're welcome Ron.

[@sureshbabugannamani7985]

THANK YOU

[@TheAkshay]

Welcome

[@prashanthng9848]

How to calculate age in ms office 2007

[@AbidHussain-xy7qt]

Not working

[@akshayhannikeri3775]

33years 11months 363days
Called as 33 Age 😂😂😂
It's 34 exactly.. (just 2 remaining days can't make it 33)(as it is almost 34 just behind 2days)