View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Rayo K
 
Posts: n/a
Default 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