Convert days into years, months and days in Excel

H

huyle2103

New member
Joined
Sep 18, 2015
Messages
6
Reaction score
0
Points
0
How to convert days into years, months and days in Excel:
I want to convert lets say 1888 Days from today to Years Months, Days!!
Ex: 1888 Days = 6 years, 3 months and 21 days
What is the formula???
Thanks
 
Don't know what the formula would be to get that, but you could try this

=DATEDIF(TODAY(),TODAY()+1888,"Y") & " years, "& DATEDIF(TODAY(),TODAY()+1888,"YM") & " months and " & DATEDIF(TODAY(),TODAY()+1888,"YM") & " days"
 
NoS said:
Don't know what the formula would be to get that, but you could try this

=DATEDIF(TODAY(),TODAY()+1888,"Y") & " years, "& DATEDIF(TODAY(),TODAY()+1888,"YM") & " months and " & DATEDIF(TODAY(),TODAY()+1888,"YM") & " days"
Click to expand...

Great, thanks you!
 
You must log in or register to reply here.
Back
Top