Blanking cells with formulas

[Loadmaster]

In cell B1 I have the formula =DATE(YEAR(A1)+2,MONTH(A1),DAY(A1)). I am
looking for something to add to the formula that if I do not have a date in
cell A1 that cell B1 remains empty until a date is entered in cell A1.

 

[FSt1]

hi
try this.......
=IF(A1="", "", DATE(YEAR(A1)+2,MONTH(A1),DAY(A1)))

regards
FSt1

 

[JP Ronse]

Hi Loadmaster,

Try

=if(A1="", "",DATE(YEAR(A1)+2,MONTH(A1),DAY(A1))

Wkr,

JP