Dates with IF statements and blank cell

Hello. I am trying to create a simple spreadsheet to track a list of tasks that will indicate ahead/behind calcs based upon a Projected Completion Date.

Let's assume the following: A1 - Today's Date, B1 - Proj Completion Date, and cell C1 is Actual Completion Date. I would like to have only one column, say D1, which would state either of these outcomes depending on the scenario:

1. Today's Date is less than Projected Completion Date (therefore Actual Completion Date is Blank) = blank
2. Todays Date is greater than Projected Completion Date (therefore Actual Completion Date is Blank) = "-5" This is simply a ahead/behind formula, same for #3 & #4.
3. Actual Completion Date is less than Projected Completion Date = "+ 5"
4. Actual Completion Date is greater than Projected Completion Date = "-5"

My trouble is when the Actual Date is input, I can't get it to go beyond the Today's date calc. I have tried ISBLANK() but to no avail. So simply put, if there is no Actual Date, then do #1 or #2. If there is an Actual Date, then do #3 or #4. Hopefully this makes sense. Thank you for any help and enjoy the weekend.

dredwolf, thank you so much for the quick reply! I will try this out and follow up.

dredwolf, this worked perfectly. I changed the +/- to formulas and it is returning consistent values. Thank you. This thread is closed.