date formula

[Roberta]

I am trying to add 1 day onto a date in several places in
non-contiguous cells. I was able to do it successfully
using the DATE function until the month would be changed
over by the addition of the day. I thought the help
screen said that it would automatically do that.

EX: =DATE(YEAR(A2),MONTH(A2),DAY(A2)+1)

When I used that to add a day to Sept. 30 it would not
return a value.
thank you!

 

[Dan E]

Roberta,

Your formula worked for me as did
=A2+1
In both cases I recieved Oct 1, 2003

Dan E