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 :

#Excel_Series

[laceycook]

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

[endingmaker]

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

[abhishekkaushik]

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

[atuldelhi]

ms office 2024 mai datedif ka function nhi show kar rhaa

[ronwalters]

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

[prashanthng]

How to calculate age in ms office 2007

[akshayhannikeri]

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)