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

[@shimpubhutiyal3833]

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

[@capabilityblack]

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

[@nochannelnamechoosen]

Thank you, I got exactly what I wanted ❤

[@mshrasel1147]

THIS FRMULA DIDNOT WORK IN OFFICE 2016

[@juniusojijo]

You saved me.. Thanks alot

[@chanderpal7840]

thank you sir ji very helpful

[@MCC-o3n]

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

[@PierreOgi_]

Well explained, thank you!

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

Very helpful 👍

[@sharmathali3108]

Can you help me to find out sum of these results

[@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?

[@ebeecorr]

Thank you so much for this information!!

[@MJTube11]

Glad it was helpful!

[@salmondevassy7521]

Nicely explained

[@ishtiaqhameed8308]

Greatttt
Thank youuu so much

[@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?

[@prrahul4182]

❤❤❤ thanks a❤❤❤

[@sanjuakshu]

what about weeks?

[@jayantabera3438]

How to added all the dates together

[@dnah02]

I don't have this formula

[@anababdiqadir3416]

how to convert year

[@shrutidubey2700]

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

[@Romariowll]

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

[@YouGotPropofol]

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

[@02010714677]

Got It...Thank You

[@k9716121441]

Awesome !