View Single Post
  #9   Report Post  
Ron Rosenfeld
 
Posts: n/a
Default formula to calculate future date from date in cell plus days

On Wed, 2 Nov 2005 17:29:02 -0800, "Chicesq"
wrote:

I want to calculate dates in the future by adding number of days to a date
existing in another cell. In other words, I want a formula in Cell A1 that
will tell me the date which is the date in Cell B1 + 25 days. How do I write
that formula. I used to have the program doing that beautifully, but when I
upgraded to new excel, my chart doesn't work any more. I used it to
calculate deadlines for legal cases. This is a real pain.


If

=B1+25 (with the result cell formatted as a date)

does not work, there is something the matter with your DATA, or with the method
in which you have set up your worksheet.

The usual mistakes have to do with getting confused as to whether the data is
really a DATE or merely a textual representation of a date.

Excel 2003 has not changed in this regard.
--ron