Yea. I'd thought of that. The only drawback there is it doesn't deal with
leap years. I know that there should be two in the next 9.79 years (so I
could subtract 2 from the total number of days I calculate) but I was hoping
that there might be some method which automatically accounted for that.

"Andy" wrote:

Hi

Try multiplying your 9.79 by 365 - as 1 in Excel is one day. You can then
add this to your date and format the result as a date.

Andy.

"Michael Lock" wrote in message
...
How do I add decimal years to a date. I know that I have 9.79 years
untill
full retirement. How do I add that to today's date to find out what my
retirement date is?