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

preview_player
Показать описание
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 "

Рекомендации по теме
Комментарии
Автор

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

capabilityblack
Автор

THIS FRMULA DIDNOT WORK IN OFFICE 2016

mshrasel
Автор

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

healthtipsonthego
Автор

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.

ishratramey
Автор

Thank you so much for this information!!

ebeecorr
Автор

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

Ampongalan
Автор

Can you help me to find out sum of these results

sharmathali
Автор

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

sarahbishop
Автор

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

Romariowll
Автор

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

DeputyBurbank
Автор

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

shrutidubey