convert Days to Years, Months, Days
How do you get 6 years 3 months and 23 days?
=DATEDIF(TODAY(),TODAY()+1890,"y")&" year(s),
"&DATEDIF(TODAY(),TODAY()+1890,"ym")&" month(s) and
"&DATEDIF(TODAY(),TODAY()+1890,"md")&" day(s)"
returns 5 years, 2 months and 2 days
--
Regards,
Peo Sjoblom
"Klaudebou" wrote in message
...
I want to convert lets say 1890 Days from today to Years Months, Days!!
Ex: 1890 Days = 6 years, 3 months and 23 days
What is the formula???
Thanks
|