Hi Steve

You're very welcome, thanks for the feedback.
I wish my retirement were that far ahead!!!

--
Regards

Roger Govier


"Steve" wrote in message
...
Perfect !! Thanks so much. It came out to be an exact match of what I
needed.
Now with the today(), &/or various future dates manually entered,
your
formula will enable me to figure out when I'm going to retire. :)

Thanks again,

Steve

"Roger Govier" wrote:

Hi Steve

One way would be to create 2 absolute dates then use the Datedif
function.
Put a starting date of say 01/01/2000 in a cell - I used C8
In cell D8 enter
=C8+13346
Then use the following formula
=DATEDIF(C8,D8,"y") &" years "&DATEDIF(C8,D8,"ym")&" months
"&DATEDIF(C8,D8,"md")&"days"

which returned 36 years 6 months 15 days for me.

--
Regards

Roger Govier


"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