View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
kbssailor kbssailor is offline
external usenet poster
 
Posts: 7
Default Calculate future date -- issue with formula?

I was using a date formula to calculate a date plus 182 days:
a1+182

It seemed to work for a time but now the calculation is resulting in a date
of January 0, 1900. I'm not even sure how it is possible that it would
reflect a date of 0...? Both cells are formatted as date cells. Any
recommendations?

Thank you!