Calculate future date -- issue with formula?

[kbssailor]

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!

 

[Peo Sjoblom]

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

 

[Ron Rosenfeld]

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!

You need to look at both your formula and at the data in the formula precedent
cells.

Also check to see that you are, indeed, doing a calculation (e.g. calculation
set to auto; edit the formula and hit <enter>).

To see exactly what is in those cells, format them as "General"

If there are formulas in the precedent cells, you'll need to look at those
precedents also.
--ron

 

[kbssailor]

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?

Thanks for your help.

 

[JE McGimpsey]

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