Adding day to date

[Roberta]

I am using the formula
=DATE(YEAR(A10),MONTH(A10),DAY(A10)+1)
to add a day to a date such as 9/29/03.
It worked fine until September had to roll over to October
1. The help screen said it would work but doesn't.
Any ideas?
Much appreciated.

 

[Dan E]

Roberta,

Again, your formula works fine for me...
so does =A10 + 1

What type of error do you get?
#VALUE???

Is it possible that the value in A10 is not a date?
Put you cursor in A10 and hit Format -> Cells
under the Number tab, if you choose Date and
toggle through the list does your sample change
accordingly?

Dan E

 

[Peo Sjoblom]

Works for me. When you say it does not work, what do you mean?
Wrong result, excel explodes?

Btw, you might as well use

=A10+1 to add one day