ISBLANK with a date formula

[erniepoe]

Trying to wrap my date formula (which works on its own) with an isblank, so that if cell L2 is blank, Excel returns a blank cell rather than Feb-1900, which it is doing.

My formula is:

=ISBLANK(L2),"",(DATE(YEAR(L2),MONTH(L2)+2,DAY(L2)))


but is getting an error message. What am I doing wrong?

 

[jeffreybrown]

How about...

=IF(ISBLANK(L2),"",DATE(YEAR(L2),MONTH(L2)+2,DAY(L2)))

 

[T. Valko]

Trying to wrap my date formula (which works on its own) with an isblank, so that if cell L2 is blank, Excel returns a blank cell rather than Feb-1900, which it is doing.

My formula is:

=ISBLANK(L2),"",(DATE(YEAR(L2),MONTH(L2)+2,DAY(L2)))


but is getting an error message. What am I doing wrong?

Here's another one...

=IF(L2="","",DATE(YEAR(L2),MONTH(L2)+2,DAY(L2)))