Do you have calculation set to Manual (Tools/Options/Calculation)?

In article ,
kbssailor wrote:

I don't understand why that would be. When I click into the cell, I see an
accurate start date (5/6/2008) and the end date formula is correct (=A1+182).


Start Date End Date
actual 5/6/2008 =A1+182
appears 6-May-08 0-Jan-00

Do you have any idea what would be causing it to equal zero?