R
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!
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!