Hi!

It doesn't work in the new excel.

What does that mean? Are you getting an incorrect result? An error?

=DATE(C3, C4+23, C5), where C3 is the month, C4 is the day, and C5 is
the year

The arguments to the Date function are, in order: Date(Year,Month,Day)

=DATEADD(C3+25)

Excel doesn't have a function like that.

Are you SURE that the date cell was in fact a true Excel date and not just a
text string that LOOKED like a date?


Biff

"Chicesq" wrote in message
...
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.