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

I didn't acoount for that, and you're right, it could potentially produce a
variance of many days. But, See Roger's solution below.

Thanks again,

Steve

"Biff" wrote:

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