[SOLVED] Keep cells blank until argument cell is filled-in

I'm working on a spreadsheet with cells formatted as dates (14-Mar-01). My goal is to enter a date in cell A2 and have cells B2, C2 and D2 populate based on the date in A2. However, I want them to remain blank until A2 is populated. With my current formulas below, I'm getting the results I'm looking for when a date is put into column A, but when column A is blank, it still shows a date in B2, C2 and D2.

Here's my current formulas:

D2 - =DATE(YEAR(A2)+1,MONTH(A2)+1,DAY(1))

C2 - =D2-15

B2 - =C2-60

With the current formulas, it provides the following results, with nothing entered in A2:

D2 - 01-Feb-01

C2 - 17-Jan-01

B2 - 18-Nov-00


So, how do I keep them blank until A2 is populated? I realize I only need to modify the D2 formula, but I'm not sure what I need to add to it to make it work.

Please help!

Wrap all your formulas in an IF() statement
D2 =IF(A2="","",DATE(YEAR(A2)+1,MONTH(A2)+1,DAY(1)))

C2 =IF(A2="","",D2-15)

B2 =IFA2="","",C2-60)

Those pesky parentheses will get you every time.