View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default Add decimal years to a date

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?