Try this:

if A1, or B1 is blank

Does blank mean EMPTY?

One way:

=IF(OR(A1="",B1=""),"",A1+1)

Biff

"slinger" wrote in message
...
I'm trying to do a chart using dates. I would like to set it so that if
A1,
or B1 is blank, then C1 is also blank. If BOTH A1 and B1 contain
information,
then C1 = A1 + 1.

I have tried this, and it doesn't work.

=IF(AND(ISBLANK($A1)),(ISBLANK(B1))),"",($A1)+1

I have also tried a few other things, all of which don't work.

Any help would be greatly appreciated.