One more small problem. E.g. , if the prior calcs resulted in 20 years, 14
months,I can figure out if months are = 12, to add a 1 to the years with
this formula
Year cell =IF(I4=12,H4+1,I4) &
Month cell =(IF(I4=12,I4-12,I4))
Yrs Months
H4 I4
20 14

21 2

This will work up to 24 months, but how could I get it to work for 24
months ?

Much appreciated,

Thanks,

Steve



"Steve" wrote:

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