View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steve Steve is offline
external usenet poster
 
Posts: 1,814
Default Year-Days-Months

If I have 13346 days, I need to find out how many years, months & days that
represents. I got as far as 13346 / 365 = 36.56, so I could get the years
with left,2, but I'm having trouble converting the .56 into a 30 day month,
and the # of days remaining.
Any help would be greatly appreciated.

Thanks,

Steve