How do you know that it is 9.79 years to retirement? How did you (or
somebody else) arrive at this figure? Presumably if you knew how this
was calculated then you could apply the appropriate formula within
Excel.

Pete