0
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.
2I think something like
=IF(ISBLANK(D11),"",D11+7)
will do what you want – cybernetic.nomad – 2019-03-29T22:22:20.647@cybernetic.nomad - why do you post answer as a comment? – ZygD – 2019-03-30T00:09:43.370