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

I tried that. It doesn't work in the new excel. Think twice before
upgrading. New excell changes all prior formulas which will no longer work.
Thank God, I'm not an accountant or something. It would be a real mess for
someone like that. What you have to do, as I finally figured out is set up a
separate column for Month, Day and Year. Then, you have to do a formula that
states =DATE(C3, C4+23, C5), where C3 is the month, C4 is the day, and C5 is
the year. I used to just put the date in one column, and then do my formulas
from that date. For instance, =DATEADD(C3+25), where C3 was the entire date
I wanted to calculate from. Can't do that any more. This new version is
much more cumbersome. Microsoft has overthought what used to be a very
simple, intuitive program, to make is complicated and unwieldy.

"Roland" wrote:

The arithmetic is simple, and you have it. Just format the cell A1 using one
of the date formats.

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