convert Days to Years, Months, Days
Try this:
If D is the total number of days:
Years = INT(D/365)
Months = INT(MOD(D,365)/30)
Days = MOD(MOD(D,365),30)
Assuming of course a 365 day year and 30 day month. If you want to put those
together, use CONCATENATE()
HTH
RJK
"Klaudebou" wrote:
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
|