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.bsocialshine.com
Пікірлер: 26
Very Helpful and well explained - just what i needed. Thank You.
Excellent......you are a genius.... God bless you.
Well explained, thank you!
THIS FRMULA DIDNOT WORK IN OFFICE 2016
Thank you so much for this information!!
@MJTube11
2 жыл бұрын
Glad it was helpful!
Thanks, you’re the best. How would you show weeks with the numbers?
You saved me.. Thanks alot
Very helpful 👍
Nicely explained
Awesome !
thank you sir ji very helpful
Greatttt Thank youuu so much
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.
Thanks dear,👍
I am wondering why 365 days did not show up as 1 year? is there a correction for this?
Can you help me to find out sum of these results
what about weeks?
How to added all the dates together
What if it's 0 years how to hide it?
how to convert year
I don't have this formula
HOW REMOVE "0 YEARS" AND FIX "1 YEARS"?
Got It...Thank You
Why wouldn’t Microsoft engineers just I close this as a built in cell format ?
10/6/2012 TO 3/7/2017 should be 5 years 0 months and 27 days.