View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
datakop datakop is offline
external usenet poster
 
Posts: 3
Default calc. an anniversary date(50 years) after marriage date in excel

I need to be able to accurately calculate an anniversary date. For example I
need to add 50 years to the marriage date e.g October 22 1960 and get October
22nd 2010.

Just adding 18,250 days does not do it. I guess, I need to take account of
leap years?

Thanks

Duncan