Jan 1, 1900 in Excel is the same as zero, meaning that if you put 0 in A1
and format it as a date it will return 01/00/1900 so somehow your formula
equals zero.


--


Regards,


Peo Sjoblom




"kbssailor" wrote in message
...
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!