Spreadsheet: 674227d1587726958-if-statement-with-networkdays-error-book1
Sheet: Sheet1

Date : Sent to Customer | Actual Collection Date - Ex Works | Customer Notified-Actual collection(Days) | Customer  Notified- Actual collection (Status) | Days - Notification to Customer | My Formula
Not Sent as yet | Not Collected |  |  |  |  |  |  | Date | Day Category | Holiday and Notable Festive Days
Not Sent as yet | Not Collected |  |  |  |  |  |  | 2020-01-01 00:00:00 | South Africa & Common | New Year's Day
2019-07-01 00:00:00 | 2019-08-30 00:00:00 |  |  |  |  |  |  | 2020-03-21 00:00:00 | South Africa & Common | Human Rights Day
2019-07-22 00:00:00 | 2020-01-07 00:00:00 |  |  |  |  |  |  | 2020-04-10 00:00:00 | Christian / Catholic | Good Friday
2019-08-05 00:00:00 | 2020-01-07 00:00:00 |  |  |  |  |  |  | 2020-04-13 00:00:00 | South Africa & Common | Family Day
2019-08-12 00:00:00 | 2019-12-09 00:00:00 |  |  |  |  |  |  | 2020-04-27 00:00:00 | South Africa & Common | Freedom Day
2019-07-17 00:00:00 | Not Collected |  |  |  |  |  |  | 2020-05-01 00:00:00 | South Africa & Common | Worker's Day
2019-09-30 00:00:00 | 2019-11-26 00:00:00 |  |  |  |  |  |  | 2020-06-16 00:00:00 | South Africa & Common | Youth's Day
2019-10-14 00:00:00 | 2020-01-06 00:00:00 |  |  |  |  |  |  | 2020-08-09 00:00:00 | South Africa & Common | National Women's Day
2019-10-16 00:00:00 | Not Collected |  |  |  |  |  |  | 2020-09-24 00:00:00 | South Africa & Common | Heritage Day
2019-10-21 00:00:00 | 2020-02-03 00:00:00 |  |  |  |  |  |  | 2020-12-16 00:00:00 | South Africa & Common | Day of Reconciliation
2019-10-29 00:00:00 | 2020-01-30 00:00:00 |  |  |  |  |  |  | 2020-12-25 00:00:00 | Christian / Catholic | Christmas
2019-10-29 00:00:00 | 2020-01-30 00:00:00 |  |  |  |  |  |  | 2020-12-26 00:00:00 | South Africa & Common | Day of Goodwill
2019-11-04 00:00:00 | 2020-04-02 00:00:00
2019-11-05 00:00:00 | 2019-12-09 00:00:00
2019-11-18 00:00:00 | Not Collected
2019-11-11 00:00:00 | Not Collected
2019-11-18 00:00:00 | 2020-01-07 00:00:00
2019-11-18 00:00:00 | 2020-01-30 00:00:00
2019-11-18 00:00:00 | 2020-01-07 00:00:00
2019-11-18 00:00:00 | 2019-12-03 00:00:00
2019-11-20 00:00:00 | 2019-12-06 00:00:00
2019-11-25 00:00:00 | 2020-01-06 00:00:00
2019-11-25 00:00:00 | 2020-01-06 00:00:00
2019-10-31 00:00:00 | Not Collected
2019-11-25 00:00:00 | 2020-01-30 00:00:00
2019-12-23 00:00:00 | Not Collected
2019-12-02 00:00:00 | 2020-02-06 00:00:00
2019-11-27 00:00:00 | Not Collected
2019-12-02 00:00:00 | 2020-01-06 00:00:00
2019-12-09 00:00:00 | 2020-01-06 00:00:00
2019-12-02 00:00:00 | 2020-02-06 00:00:00
2019-12-02 00:00:00 | 2020-01-06 00:00:00
2019-12-02 00:00:00 | 2020-01-06 00:00:00
2019-12-02 00:00:00 | 2020-01-07 00:00:00
2019-12-02 00:00:00 | 2020-01-06 00:00:00
2019-11-29 00:00:00 | Not Collected
2019-11-29 00:00:00 | Not Collected
2019-12-03 00:00:00 | 2019-12-25 00:00:00
2019-11-29 00:00:00 | Not Collected
2019-12-03 00:00:00 | Not Collected
2019-12-09 00:00:00 | 2020-02-06 00:00:00
2019-12-09 00:00:00 | 2020-02-06 00:00:00
2019-12-09 00:00:00 | 2020-01-06 00:00:00
2019-12-09 00:00:00 | 2020-01-06 00:00:00
2019-12-09 00:00:00 | 2020-01-06 00:00:00
2019-12-09 00:00:00 | 2020-01-06 00:00:00
2019-12-09 00:00:00 | 2020-01-06 00:00:00
2019-12-09 00:00:00 | 2020-01-06 00:00:00
2019-12-09 00:00:00 | 2020-01-27 00:00:00
2019-12-09 00:00:00 | 2020-01-30 00:00:00
2019-12-09 00:00:00 | 2020-01-07 00:00:00
2019-12-09 00:00:00 | 2020-01-07 00:00:00
2019-12-09 00:00:00 | 2020-01-06 00:00:00
2019-12-23 00:00:00 | 2019-12-27 00:00:00
2019-12-17 00:00:00 | 2020-01-06 00:00:00
2019-12-17 00:00:00 | 2020-01-06 00:00:00
2019-12-17 00:00:00 | 2020-01-06 00:00:00
2019-12-17 00:00:00 | 2020-01-30 00:00:00
2019-12-17 00:00:00 | 2020-01-06 00:00:00
2019-12-17 00:00:00 | 2020-01-16 00:00:00
2019-12-23 00:00:00 | 2020-01-13 00:00:00
2019-12-23 00:00:00 | Not Collected
2019-12-23 00:00:00 | 2020-01-24 00:00:00
2019-12-23 00:00:00 | 2020-01-24 00:00:00
2019-12-23 00:00:00 | 2020-01-06 00:00:00
2019-12-23 00:00:00 | 2020-01-06 00:00:00
2019-12-23 00:00:00 | Not Collected
2019-12-25 00:00:00 | 2020-01-27 00:00:00
2020-01-09 00:00:00 | Not Collected
2020-01-09 00:00:00 | Not Collected
2020-01-09 00:00:00 | Not Collected
2020-01-09 00:00:00 | Not Collected
2020-01-13 00:00:00 | 2020-01-29 00:00:00
2020-01-27 00:00:00 | Not Collected
2020-02-03 00:00:00 | Not Collected
2020-01-14 00:00:00 | 2020-02-03 00:00:00
2020-01-14 00:00:00 | 2020-01-30 00:00:00
2020-01-14 00:00:00 | 2020-01-27 00:00:00
2020-01-20 00:00:00 | 2020-04-02 00:00:00
2020-01-20 00:00:00 | Not Collected
2020-01-20 00:00:00 | 2020-02-24 00:00:00
2020-01-20 00:00:00 | Not Collected
2020-01-20 00:00:00 | 2020-02-06 00:00:00
2020-02-03 00:00:00 | Not Collected
2020-01-20 00:00:00 | Not Collected
2020-01-20 00:00:00 | Not Collected
2020-01-27 00:00:00 | 2020-03-26 00:00:00
2020-01-27 00:00:00 | 2020-02-06 00:00:00
2020-01-27 00:00:00 | 2020-02-06 00:00:00
2020-01-27 00:00:00 | 2020-02-06 00:00:00
2020-01-27 00:00:00 | 2020-02-14 00:00:00
2020-01-27 00:00:00 | 2020-02-14 00:00:00
2020-01-27 00:00:00 | 2020-02-14 00:00:00
2020-01-27 00:00:00 | 2020-02-14 00:00:00
2020-01-27 00:00:00 | 2020-02-14 00:00:00
2020-01-27 00:00:00 | 2020-02-14 00:00:00
2020-01-27 00:00:00 | 2020-02-14 00:00:00
2020-01-27 00:00:00 | 2020-02-14 00:00:00
2020-01-27 00:00:00 | 2020-02-14 00:00:00
2020-01-27 00:00:00 | Not Collected
2020-01-27 00:00:00 | 2020-02-06 00:00:00
2020-01-27 00:00:00 | Not Collected
2020-01-27 00:00:00 | 2020-02-06 00:00:00
2020-01-27 00:00:00 | Not Collected
2020-01-27 00:00:00 | 2020-02-07 00:00:00
2020-01-13 00:00:00 | Not Collected
2020-01-13 00:00:00 | Not Collected
2020-01-31 00:00:00 | 2020-02-13 00:00:00
2020-01-29 00:00:00 | Not Collected
2020-02-03 00:00:00 | Not Collected
2020-02-03 00:00:00 | 2020-03-26 00:00:00
2020-01-20 00:00:00 | Not Collected
2020-02-03 00:00:00 | 2020-02-25 00:00:00
2020-02-03 00:00:00 | 2020-02-25 00:00:00
2020-02-03 00:00:00 | 2020-02-25 00:00:00
2020-01-28 00:00:00 | Not Collected
2020-02-03 00:00:00 | Not Collected
2020-02-03 00:00:00 | 2020-03-06 00:00:00
2020-02-10 00:00:00 | 2020-03-02 00:00:00
2020-02-10 00:00:00 | 2020-03-02 00:00:00
2020-02-10 00:00:00 | 2020-03-02 00:00:00
2020-02-10 00:00:00 | 2020-03-02 00:00:00
2020-02-06 00:00:00 | Not Collected
2020-02-10 00:00:00 | Not Collected
2020-02-17 00:00:00 | Not Collected
2020-02-17 00:00:00 | Not Collected
2020-02-14 00:00:00 | Not Collected
2020-02-17 00:00:00 | Not Collected
2020-02-17 00:00:00 | Not Collected
2020-02-17 00:00:00 | 2020-02-25 00:00:00
2020-02-17 00:00:00 | Not Collected
2020-02-17 00:00:00 | Not Collected
2020-02-17 00:00:00 | Not Collected
2020-02-24 00:00:00 | 2020-03-31 00:00:00
2020-02-24 00:00:00 | Not Collected
2020-02-24 00:00:00 | Not Collected
2020-02-24 00:00:00 | Not Collected
2020-02-24 00:00:00 | Not Collected
2020-02-24 00:00:00 | Not Collected
2020-02-24 00:00:00 | 2020-04-02 00:00:00
2020-02-24 00:00:00 | Not Collected
2020-03-02 00:00:00 | 2020-03-25 00:00:00
2020-03-02 00:00:00 | Not Collected
2020-03-02 00:00:00 | Not Collected
2020-03-02 00:00:00 | Not Collected
2020-03-02 00:00:00 | Not Collected
2020-03-02 00:00:00 | Not Collected
2020-03-08 00:00:00 | Not Collected
2020-02-24 00:00:00 | Not Collected
2020-03-09 00:00:00 | Not Collected
2020-03-09 00:00:00 | 2020-03-31 00:00:00
2020-03-09 00:00:00 | 2020-03-06 00:00:00
2020-03-16 00:00:00 | 2020-03-31 00:00:00
2020-03-11 00:00:00 | Not Collected
2020-03-16 00:00:00 | 2020-04-02 00:00:00
2020-03-16 00:00:00 | Not Collected
2020-03-16 00:00:00 | Not Collected
2020-03-16 00:00:00 | Not Collected
2020-03-16 00:00:00 | Not Collected
2020-03-16 00:00:00 | Not Collected
2020-03-23 00:00:00 | Not Collected
2020-03-23 00:00:00 | Not Collected
2020-03-23 00:00:00 | 2020-04-02 00:00:00
2020-03-23 00:00:00 | Not Collected
2020-03-23 00:00:00 | Not Collected
2020-03-23 00:00:00 | Not Collected
2020-03-23 00:00:00 | Not Collected
2020-03-23 00:00:00 | 2020-04-02 00:00:00
2020-03-23 00:00:00 | Not Collected
2020-03-25 00:00:00 | 2020-04-02 00:00:00
2020-03-25 00:00:00 | 2020-04-02 00:00:00
2020-03-25 00:00:00 | Not Collected
2020-03-25 00:00:00 | 2020-03-26 00:00:00
2020-03-26 00:00:00 | 2020-04-02 00:00:00
2020-04-01 00:00:00 | Not Collected
2020-04-01 00:00:00 | Not Collected
2020-04-01 00:00:00 | Not Collected
2020-04-01 00:00:00 | Not Collected
2020-04-01 00:00:00 | Not Collected
2020-04-03 00:00:00 | Not Collected
2020-04-03 00:00:00 | Not Collected
2020-04-03 00:00:00 | Not Collected
2020-04-03 00:00:00 | Not Collected
2020-04-06 00:00:00 | Not Collected
2020-04-13 00:00:00 | Not Collected
2020-04-13 00:00:00 | 2020-04-22 00:00:00
2020-04-14 00:00:00 | Not Collected
2020-04-14 00:00:00 | Not Collected
2020-04-20 00:00:00 | Not Collected
2020-04-15 00:00:00 | Not Collected
2020-04-16 00:00:00 | Not Collected
2020-04-16 00:00:00 | Not Collected
2020-04-15 00:00:00 | Not Collected
2020-04-20 00:00:00 | Not Collected
2020-04-20 00:00:00 | Not Collected
2020-04-22 00:00:00 | Not Collected
2020-04-20 00:00:00 | Not Collected
2020-04-20 00:00:00 | Not Collected
2020-04-20 00:00:00 | Not Collected
Not Sent as yet | Not Collected
Not Sent as yet | Not Collected
Not Sent as yet | Not Collected
Not Sent as yet | Not Collected