So basically, "INVOICE DUE DATE" is the SUM of D11+7 ("Date invoice sent out" + 7 days as this is when the invoice is due). However, when there is no date inputted in "DATE INVOICE SENT OUT" the "INVOICE DUE DATE" cell shows
07/01/1900. I want it to show blank until I input a date into D11.
Also - the "DAYS REMAINING" column (K11) is made up of E11-B2 (invoice due date -
=TODAY(). I again want this to show as blank until the SUM is complete.
Finally - 2day, 4day and 6day chase are made up of D11+2,D11+4 and D11+6. I want these to show as blank until D11 date entered.