View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default Calculate future date -- issue with formula?

On Mon, 12 May 2008 09:46:00 -0700, kbssailor
wrote:

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