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

That's how I used to have it set up. Doesn't work in newest version of
Excel. Think twice before upgrading. Throws all previous formulas off, and
is more compliated to create new ones.

"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.