Spreadsheet: 800501d1665689073-date-formula-to-show-on-time-and-late-with-exceptions-sample
Sheet: TAFQAR

TAFQAR Date | Mfg | Mfg docs to QA | TAFQAR STATUS MFG | Column1
2022-10-03 00:00:00 | 2022-09-16 00:00:00 | 2022-10-03 00:00:00 |  |  |  | [QUOTE]If column D is <=5 days of column B then it would be On Time  If column C is blank then no documentation required and would be On Time  I column D is blank but has not gone past the 5 days then On Time  Row 122 should still show On Time because the current date 10/12/2022. Column C would not be late until 10/18/2022
2022-10-03 00:00:00 | 2022-09-07 00:00:00 | 2022-09-08 00:00:00
2022-10-03 00:00:00
2022-10-03 00:00:00
2022-10-03 00:00:00
2022-10-04 00:00:00
2022-10-04 00:00:00 | 2022-08-03 00:00:00 | 2022-08-12 00:00:00
2022-10-04 00:00:00 | 2022-09-13 00:00:00 | 2022-09-19 00:00:00
2022-10-04 00:00:00 | 2022-09-14 00:00:00 | 2022-09-26 00:00:00
2022-10-04 00:00:00 | 2022-09-16 00:00:00 | 2022-09-26 00:00:00
2022-10-04 00:00:00 | 2022-09-04 00:00:00 | 2022-09-26 00:00:00
2022-10-04 00:00:00 | 2022-09-02 00:00:00 | 2022-09-23 00:00:00
2022-10-05 00:00:00 | 2022-07-06 00:00:00 | 2022-08-12 00:00:00
2022-10-05 00:00:00 | 2022-08-21 00:00:00 | 2022-07-15 00:00:00
2022-10-05 00:00:00 | 2022-09-15 00:00:00 | 2022-09-15 00:00:00
2022-10-05 00:00:00 | 2022-09-17 00:00:00 | 2022-10-03 00:00:00
2022-10-05 00:00:00
2022-10-05 00:00:00
2022-10-06 00:00:00 | 2022-09-01 00:00:00 | 2022-09-26 00:00:00
2022-10-06 00:00:00 | 2022-09-03 00:00:00 | 2022-09-26 00:00:00
2022-10-06 00:00:00 | 2022-08-01 00:00:00 | 2022-08-17 00:00:00
2022-10-06 00:00:00 | 2022-09-18 00:00:00 | 2022-09-27 00:00:00
2022-10-06 00:00:00 | 2022-09-05 00:00:00 | 2022-09-26 00:00:00
2022-10-06 00:00:00 | 2022-09-23 00:00:00 | 2022-09-23 00:00:00
2022-10-06 00:00:00 | 2022-09-13 00:00:00 | 2022-09-27 00:00:00
2022-10-07 00:00:00 | 2022-09-20 00:00:00 | 2022-10-03 00:00:00
2022-10-07 00:00:00 | 2022-09-19 00:00:00 | 2022-09-21 00:00:00
2022-10-07 00:00:00 | 2022-09-21 00:00:00 | 2022-10-03 00:00:00
2022-10-07 00:00:00 | 2022-09-21 00:00:00 | 2022-10-06 00:00:00
2022-10-07 00:00:00 | 2022-09-22 00:00:00 | 2022-10-03 00:00:00
2022-10-07 00:00:00 | 2022-09-20 00:00:00 | 2022-09-15 00:00:00
2022-10-07 00:00:00 | 2022-08-02 00:00:00 | 2022-08-17 00:00:00
2022-10-07 00:00:00 | 2022-08-26 00:00:00 | 2022-09-06 00:00:00
2022-10-07 00:00:00 | 2022-10-01 00:00:00
2022-10-07 00:00:00
2022-10-07 00:00:00
2022-10-08 00:00:00
2022-10-10 00:00:00 | 2022-07-26 00:00:00 | 2022-08-01 00:00:00
2022-10-10 00:00:00 | 2022-08-30 00:00:00 | 2022-09-23 00:00:00
2022-10-10 00:00:00 | 2022-08-15 00:00:00 | 2022-08-17 00:00:00
2022-10-10 00:00:00 | 2022-08-16 00:00:00 | 2022-08-31 00:00:00
2022-10-10 00:00:00 | 2022-09-11 00:00:00 | 2022-09-13 00:00:00
2022-10-10 00:00:00 | 2022-09-13 00:00:00 | 2022-09-26 00:00:00
2022-10-10 00:00:00 | 2022-09-08 00:00:00 | 2022-09-26 00:00:00
2022-10-10 00:00:00 | 2022-09-03 00:00:00 | 2022-08-25 00:00:00
2022-10-10 00:00:00
2022-10-10 00:00:00
2022-10-10 00:00:00 | 2022-09-12 00:00:00
2022-10-10 00:00:00 | 2022-09-15 00:00:00
2022-10-10 00:00:00 | 2022-09-14 00:00:00
2022-10-11 00:00:00 | 2022-08-18 00:00:00 | 2022-09-06 00:00:00
2022-10-11 00:00:00 | 2022-08-21 00:00:00 | 2022-09-28 00:00:00
2022-10-11 00:00:00 | 2022-08-19 00:00:00 | 2022-10-03 00:00:00
2022-10-11 00:00:00 | 2022-09-22 00:00:00 | 2022-09-26 00:00:00
2022-10-11 00:00:00 | 2022-09-25 00:00:00
2022-10-12 00:00:00
2022-10-12 00:00:00
2022-10-12 00:00:00
2022-10-13 00:00:00 | 2022-06-27 00:00:00 | 2022-07-11 00:00:00
2022-10-13 00:00:00 | 2022-08-17 00:00:00 | 2022-08-22 00:00:00
2022-10-13 00:00:00
2022-10-13 00:00:00 | 2022-08-21 00:00:00 | 2022-09-12 00:00:00
2022-10-13 00:00:00 | 2022-09-25 00:00:00
2022-10-13 00:00:00 | 2022-09-09 00:00:00 | 2022-09-30 00:00:00
2022-10-13 00:00:00 | 2022-09-16 00:00:00
2022-10-13 00:00:00
2022-10-13 00:00:00
2022-10-14 00:00:00
2022-10-14 00:00:00
2022-10-14 00:00:00 | 2022-08-30 00:00:00
2022-10-14 00:00:00 | 2022-08-18 00:00:00 | 2022-08-29 00:00:00
2022-10-14 00:00:00 | 2022-09-28 00:00:00
2022-10-14 00:00:00
2022-10-14 00:00:00
2022-10-15 00:00:00
2022-10-15 00:00:00
2022-10-16 00:00:00
2022-10-16 00:00:00
2022-10-17 00:00:00 | 2022-09-26 00:00:00
2022-10-17 00:00:00 | 2022-09-29 00:00:00
2022-10-17 00:00:00
2022-10-17 00:00:00 | 2022-09-07 00:00:00 | 2022-09-09 00:00:00
2022-10-17 00:00:00 | 2022-09-09 00:00:00 | 2022-09-22 00:00:00
2022-10-17 00:00:00
2022-10-17 00:00:00
2022-10-17 00:00:00 | 2022-09-13 00:00:00
2022-10-17 00:00:00 | 2022-09-13 00:00:00
2022-10-17 00:00:00 | 2022-09-15 00:00:00
2022-10-17 00:00:00 | 2022-09-24 00:00:00
2022-10-17 00:00:00
2022-10-17 00:00:00
2022-10-18 00:00:00 | 2022-09-08 00:00:00 | 2022-09-20 00:00:00
2022-10-18 00:00:00 | 2022-09-13 00:00:00 | 2022-09-20 00:00:00
2022-10-18 00:00:00 | 2022-09-14 00:00:00 | 2022-09-20 00:00:00
2022-10-18 00:00:00 | 2022-09-16 00:00:00
2022-10-18 00:00:00
2022-10-18 00:00:00
2022-10-20 00:00:00 | 2022-09-17 00:00:00 | 2022-10-05 00:00:00
2022-10-20 00:00:00 | 2022-09-02 00:00:00 | 2022-10-05 00:00:00
2022-10-20 00:00:00 | 2022-09-17 00:00:00 | 2022-09-23 00:00:00
2022-10-20 00:00:00 | 2022-09-19 00:00:00 | 2022-09-26 00:00:00
2022-10-20 00:00:00
2022-10-20 00:00:00
2022-10-20 00:00:00
2022-10-21 00:00:00 | 2022-09-22 00:00:00 | 2022-09-23 00:00:00
2022-10-21 00:00:00 | 2022-08-25 00:00:00 | 2022-09-06 00:00:00
2022-10-21 00:00:00 | 2022-08-28 00:00:00 | 2022-09-13 00:00:00
2022-10-21 00:00:00 | 2022-08-31 00:00:00 | 2022-10-03 00:00:00
2022-10-21 00:00:00 | 2022-09-01 00:00:00 | 2022-09-07 00:00:00
2022-10-21 00:00:00 | 2022-09-23 00:00:00 |  |  | On Time |  | Since today is 10/13/2022 this will be on time until we get to 10/17/2022.  This document is required to be turned in 5 days before the [NAME] target date.
2022-10-21 00:00:00 | 2022-09-01 00:00:00 | 2022-09-01 00:00:00
2022-10-21 00:00:00 | 2022-09-25 00:00:00 | 2022-09-23 00:00:00
2022-10-21 00:00:00 | 2022-09-04 00:00:00 | 2022-09-09 00:00:00
2022-10-21 00:00:00 | 2022-09-21 00:00:00 |  |  | On Time |  | Since today is 10/13/2022 this will be on time until we get to 10/17/2022.  This document is required to be turned in 5 days before the [NAME] target date.
2022-10-21 00:00:00 | 2022-09-10 00:00:00 |  |  | On Time |  | Since today is 10/13/2022 this will be on time until we get to 10/17/2022.  This document is required to be turned in 5 days before the [NAME] target date.
2022-10-21 00:00:00 | 2022-09-23 00:00:00 |  |  | On Time |  | Since today is 10/13/2022 this will be on time until we get to 10/17/2022.  This document is required to be turned in 5 days before the [NAME] target date.
2022-10-21 00:00:00
2022-10-24 00:00:00 | 2022-08-21 00:00:00 | 2022-09-09 00:00:00
2022-10-24 00:00:00 | 2022-09-26 00:00:00 | 2022-10-03 00:00:00
2022-10-24 00:00:00
2022-10-24 00:00:00 | 2022-09-22 00:00:00 |  |  | On Time |  | Until we reach 10/20/2022 this is still on time
2022-10-24 00:00:00 | 2022-09-03 00:00:00 | 2022-08-31 00:00:00
2022-10-24 00:00:00 | 2022-09-23 00:00:00 | 2022-09-26 00:00:00
2022-10-24 00:00:00 | 2022-08-27 00:00:00 | 2022-08-25 00:00:00 |  |  |  |  |  | Anything that shows Late the rest of the way down should be on time until we get inside the 5 day window
2022-10-24 00:00:00 | 2022-09-08 00:00:00
2022-10-24 00:00:00 | 2022-09-11 00:00:00
2022-10-24 00:00:00
2022-10-24 00:00:00
2022-10-25 00:00:00 | 2022-08-23 00:00:00 | 2022-09-01 00:00:00
2022-10-25 00:00:00 | 2022-08-26 00:00:00 | 2022-09-09 00:00:00
2022-10-25 00:00:00
2022-10-25 00:00:00 | 2022-09-22 00:00:00 | 2022-09-22 00:00:00
2022-10-25 00:00:00 | 2022-09-26 00:00:00
2022-10-25 00:00:00 | 2022-09-26 00:00:00
2022-10-25 00:00:00
2022-10-25 00:00:00
2022-10-26 00:00:00
2022-10-27 00:00:00
2022-10-27 00:00:00
2022-10-27 00:00:00 | 2022-09-28 00:00:00
2022-10-27 00:00:00 | 2022-08-29 00:00:00 | 2022-09-09 00:00:00
2022-10-27 00:00:00 | 2022-09-10 00:00:00
2022-10-27 00:00:00
2022-10-27 00:00:00
2022-10-28 00:00:00 | 2022-07-22 00:00:00 | 2022-07-28 00:00:00
2022-10-28 00:00:00 | 2022-08-26 00:00:00
2022-10-28 00:00:00 | 2022-08-27 00:00:00 | 2022-08-31 00:00:00
2022-10-28 00:00:00
2022-10-28 00:00:00
2022-10-28 00:00:00
2022-10-28 00:00:00
2022-10-28 00:00:00
2022-10-28 00:00:00 | 2022-09-29 00:00:00
2022-10-28 00:00:00
2022-10-28 00:00:00
2022-10-28 00:00:00
2022-10-28 00:00:00
2022-10-31 00:00:00 | 2022-08-27 00:00:00 | 2022-08-02 00:00:00
2022-10-31 00:00:00 | 2022-08-28 00:00:00 | 2022-09-09 00:00:00
2022-10-31 00:00:00 | 2022-08-28 00:00:00 | 2022-08-05 00:00:00
2022-10-31 00:00:00