View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MareskiCP MareskiCP is offline
external usenet poster
 
Posts: 2
Default Calculating to add years - including leap year

I have a function that needs to add 3 years to a date field. I am currently
adding 1095 days (3 years x 365) to the base number, but if there is a leap
year in those three, I'm off by one day. How can I add three years and make
sure that the extra day is included if one year is a leap year?