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

Hi!

Are you sure you want to use a 30 day month with a 365 day year?

If so, what result would you expect from 364 days?

Biff

"Steve" wrote in message
...
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