MS Excel: How to Convert Days & Dates into Years Months & Days

Convert Date & Days into year month & days.
Days convert formula:
=DATEDIF(0,D5,"Y")&" Years "&DATEDIF(0,D5,"YM")&" Months "&DATEDIF(0,D5,"MD")&" Days "
Date convert formula:
=DATEDIF(C10,D10,"Y")&" Years "&DATEDIF(C10,D10,"YM")&" Months "&DATEDIF(C10,D10,"MD")&" Days "
Facebook Page : / memjtube
Follow on twitter: / mj1111983
Website : www.bsocialshin...

[@shimpubhutiyal3833]

Excellent......you are a genius.... God bless you.

[@MCC-o3n]

Could we have the same formula but adding "weeks"?
Thanks!

[@capabilityblack]

Very Helpful and well explained - just what i needed. Thank You.

[@chanderpal7840]

thank you sir ji very helpful

[@juniusojijo]

You saved me.. Thanks alot

[@ishratramey5887]

Hi I find you video on excel is very helpful its my second video of yours kindly guide me what if excel shows ("#NUM!") how to fix this,
its shows when i copy your formula explain in this video however i enter correct cell number.
thank you so much.

[@healthtipsonthego]

Thanks, you’re the best. How would you show weeks with the numbers?

[@PierreOgi_]

Well explained, thank you!

[@mshrasel1147]

THIS FRMULA DIDNOT WORK IN OFFICE 2016

[@ebeecorr]

Thank you so much for this information!!

[@MJTube11]

Glad it was helpful!

[@श्रीस्वामीसमर्थ-ग7त]

Very helpful 👍

[@ishtiaqhameed8308]

Greatttt
Thank youuu so much

[@prrahul4182]

❤❤❤ thanks a❤❤❤

[@salmondevassy7521]

Nicely explained

[@sharmathali3108]

Can you help me to find out sum of these results

[@sarahbishop3573]

I am wondering why 365 days did not show up as 1 year? is there a correction for this?

[@niceguy8251]

Thanks dear,👍

[@Ampongalan]

What if it's 0 years how to hide it?

[@02010714677]

Got It...Thank You

[@jayantabera3438]

How to added all the dates together

[@sanjuakshu]

what about weeks?

[@k9716121441]

Awesome !

[@shrutidubey2700]

10/6/2012 TO 3/7/2017 should be 5 years 0 months and 27 days.

[@YouGotPropofol]

Why wouldn’t Microsoft engineers just I close this as a built in cell format ?

[@dnah02]

I don't have this formula

[@Romariowll]

HOW REMOVE "0 YEARS" AND FIX "1 YEARS"?

[@anababdiqadir3416]

how to convert year