=IF(COUNTBLANKS(A1:B1)=2,"",A1+1)

Enter in C1

Dave
--
Brevity is the soul of wit.


"slinger" wrote:

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.