OK, here's an easy one for you, but I can't get it to work ....
I have the Contract date in column C
The Return date in column D =c5=30
Today in column E
How many days left in column F =IF(C9,"", D9-E9)
How many days out in Column G =IF(F5>6,"","Days Out")
Call Client in Column H =IF(F5>6,"","Follow-up ~ Call Client")
The problem ...
If I don't have a date in Column C - I don't want to see anything in Column F
So I put =if(c5,"",D5-E5)
it gives me a -42001 instead of leaving the cell blank.