Spreadsheet: 800400d1665655602-date-formula-to-show-on-time-and-late-with-exceptions-sample-etaf-3
Sheet: TAFQAR

Material description | TAFQAR Date | Mfg | Mfg docs to QA | TAFQAR STATUS MFG | Column1
CLARITIN D-24HR TAB BC 15CT CPN 87566641 | 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
CLARITIN D-12HR TAB BC 30CT CPN 87566374 | 2022-10-03 00:00:00 | 2022-09-07 00:00:00 | 2022-09-08 00:00:00
CLARITIN D-24HR TAB BC 15CT CPN 87566641 | 2022-10-03 00:00:00
IBUPROFEN 400MG CAPS X 120 CAN- COS | 2022-10-03 00:00:00
IBUPROFEN 400MG CAPS X 120 CAN- COS | 2022-10-03 00:00:00
CLARITIN D-24HR TAB BC 15CT CPN 87566641 | 2022-10-04 00:00:00
PENTASA 500MG CAPSULES X 120 - S | 2022-10-04 00:00:00 | 2022-08-03 00:00:00 | 2022-08-12 00:00:00
PENTASA 500MG CAPSULES X 120 - S | 2022-10-04 00:00:00 | 2022-09-13 00:00:00 | 2022-09-19 00:00:00
PENTASA 500MG CAPSULES X 120 - S | 2022-10-04 00:00:00 | 2022-09-14 00:00:00 | 2022-09-26 00:00:00
PENTASA 500MG CAPSULES X 120 - S | 2022-10-04 00:00:00 | 2022-09-16 00:00:00 | 2022-09-26 00:00:00
ADDERALL XR 30MG CAPS X 100, US 2X - S | 2022-10-04 00:00:00 | 2022-09-04 00:00:00 | 2022-09-26 00:00:00
ADDERALL XR 30MG CAPS X 100, US 2X - S | 2022-10-04 00:00:00 | 2022-09-02 00:00:00 | 2022-09-23 00:00:00
AURYXIA 210MG TABLETS BOTTLE X 200 - S | 2022-10-05 00:00:00 | 2022-07-06 00:00:00 | 2022-08-12 00:00:00
AURYXIA 210MG TABLETS BOTTLE X 200 - S | 2022-10-05 00:00:00 | 2022-08-21 00:00:00 | 2022-07-15 00:00:00
Vazalore (Aspirin) 325mg capsules 30ct | 2022-10-05 00:00:00 | 2022-09-15 00:00:00 | 2022-09-15 00:00:00
CLARITIN D-24HR TAB BC 15CT CPN 87566641 | 2022-10-05 00:00:00 | 2022-09-17 00:00:00 | 2022-10-03 00:00:00
DOXYCYCLINE USP 40MG CAPS X30 PRASCO - S | 2022-10-05 00:00:00
DOXYCYCLINE USP 40MG CAPS X30 PRASCO - S | 2022-10-05 00:00:00
PENTASA 500MG CAPSULES X 120 - S | 2022-10-06 00:00:00 | 2022-09-01 00:00:00 | 2022-09-26 00:00:00
PENTASA 500MG CAPSULES X 120 - S | 2022-10-06 00:00:00 | 2022-09-03 00:00:00 | 2022-09-26 00:00:00
M AMPHET SALTS 15MG CAPS X100 SANDOZ - S | 2022-10-06 00:00:00 | 2022-08-01 00:00:00 | 2022-08-17 00:00:00
ADDERALL XR 15MG CAPS X 100, US 2X - S | 2022-10-06 00:00:00 | 2022-09-18 00:00:00 | 2022-09-27 00:00:00
ADDERALL XR 10MG CAPS X 100, US 2X - S | 2022-10-06 00:00:00 | 2022-09-05 00:00:00 | 2022-09-26 00:00:00
Vazalore (Aspirin) 81mg capsules 30ct | 2022-10-06 00:00:00 | 2022-09-23 00:00:00 | 2022-09-23 00:00:00
SPD503 4MG TABS BULK EU/ROW PHZELL API | 2022-10-06 00:00:00 | 2022-09-13 00:00:00 | 2022-09-27 00:00:00
Singulair Oral Granule 4 mg | 2022-10-07 00:00:00 | 2022-09-20 00:00:00 | 2022-10-03 00:00:00
Singulair Oral Granule 4 mg | 2022-10-07 00:00:00 | 2022-09-19 00:00:00 | 2022-09-21 00:00:00
Singulair Oral Granule 4 mg | 2022-10-07 00:00:00 | 2022-09-21 00:00:00 | 2022-10-03 00:00:00
Singulair Oral Granule 4 mg | 2022-10-07 00:00:00 | 2022-09-21 00:00:00 | 2022-10-06 00:00:00
Singulair Oral Granule 4 mg | 2022-10-07 00:00:00 | 2022-09-22 00:00:00 | 2022-10-03 00:00:00
VYVANSE 60MG CAPSULES X 100 CANADA | 2022-10-07 00:00:00 | 2022-09-20 00:00:00 | 2022-09-15 00:00:00
M AMPHET SALTS 15MG CAPS X100 SANDOZ - S | 2022-10-07 00:00:00 | 2022-08-02 00:00:00 | 2022-08-17 00:00:00
ADDERALL XR CAPSULES, 5 MG - S | 2022-10-07 00:00:00 | 2022-08-26 00:00:00 | 2022-09-06 00:00:00
SPD503 2MG TABS BULK EU/ROW PHZELL API | 2022-10-07 00:00:00 | 2022-10-01 00:00:00
IBUPROFEN 200MG CAPS X 250 CAN- COS | 2022-10-07 00:00:00
IBUPROFEN 200MG CAPS X 250 CAN- COS | 2022-10-07 00:00:00
IBUPROFEN 200MG CAPS X 250 CAN- COS | 2022-10-08 00:00:00
FOSRENOL AG PRASCO 1000MG X 10CTN X9 -S | 2022-10-10 00:00:00 | 2022-07-26 00:00:00 | 2022-08-01 00:00:00
AURYXIA 210MG TABLETS BOTTLE X 200 - S | 2022-10-10 00:00:00 | 2022-08-30 00:00:00 | 2022-09-23 00:00:00
M AMPHET SALTS 20MG CAPS X100 SANDOZ - S | 2022-10-10 00:00:00 | 2022-08-15 00:00:00 | 2022-08-17 00:00:00
M AMPHET SALTS 20MG CAPS X100 SANDOZ - S | 2022-10-10 00:00:00 | 2022-08-16 00:00:00 | 2022-08-31 00:00:00
ADDERALL XR 20MG CAPS X 100, US 2X - S | 2022-10-10 00:00:00 | 2022-09-11 00:00:00 | 2022-09-13 00:00:00
ADDERALL XR 20MG CAPS X 100, US 2X - S | 2022-10-10 00:00:00 | 2022-09-13 00:00:00 | 2022-09-26 00:00:00
ADDERALL XR 20MG CAPS X 100, US 2X - S | 2022-10-10 00:00:00 | 2022-09-08 00:00:00 | 2022-09-26 00:00:00
AURYXIA 210MG TABLETS BOTTLE X 200 - S | 2022-10-10 00:00:00 | 2022-09-03 00:00:00 | 2022-08-25 00:00:00
CLARITIN D-24HR TAB BC 15CT CPN 87566641 | 2022-10-10 00:00:00
CLARITIN D-24HR TAB BC 15CT CPN 87566641 | 2022-10-10 00:00:00
JAKAFI 5MG TAB DRUM  X75,000 (150KG) | 2022-10-10 00:00:00 | 2022-09-12 00:00:00
[NAME] TABLETS DRUM X 12,000 | 2022-10-10 00:00:00 | 2022-09-15 00:00:00
[NAME] (50KG) | 2022-10-10 00:00:00 | 2022-09-14 00:00:00
VYVANSE 30MG CAPS X 100 QLCPS, US 2X - S | 2022-10-11 00:00:00 | 2022-08-18 00:00:00 | 2022-09-06 00:00:00
M AMPHET SALTS 25MG CAPS X100 SANDOZ - S | 2022-10-11 00:00:00 | 2022-08-21 00:00:00 | 2022-09-28 00:00:00
M AMPHET SALTS 20MG CAPS X100 SANDOZ - S | 2022-10-11 00:00:00 | 2022-08-19 00:00:00 | 2022-10-03 00:00:00
ADDERALL XR 20MG CAPS X 100, US 2X - S | 2022-10-11 00:00:00 | 2022-09-22 00:00:00 | 2022-09-26 00:00:00
ADDERALL XR 30MG CAPS X 100, US 2X - S | 2022-10-11 00:00:00 | 2022-09-25 00:00:00
CLARITIN D-24HR TAB BC 15CT CPN 87566641 | 2022-10-12 00:00:00
[NAME] 20MG TABLETS DRUM X 20,000 | 2022-10-12 00:00:00
IBUPROFEN 200MG CAPS X 250 CAN- COS | 2022-10-12 00:00:00
ADDERALL XR 25MG CAPS X 100, US 2X - S | 2022-10-13 00:00:00 | 2022-06-27 00:00:00 | 2022-07-11 00:00:00
M AMPHET SALTS 20MG CAPS X100 SANDOZ - S | 2022-10-13 00:00:00 | 2022-08-17 00:00:00 | 2022-08-22 00:00:00
TRINTELLIX 10mg TAB x 7 SAMPLE | 2022-10-13 00:00:00
M AMPHET SALTS 20MG CAPS X100 SANDOZ - S | 2022-10-13 00:00:00 | 2022-08-21 00:00:00 | 2022-09-12 00:00:00
M AMPHET SALTS 20MG CAPS X100 SANDOZ - S | 2022-10-13 00:00:00 | 2022-09-25 00:00:00
SPD503 1MG TABS BULK CHEMO API JAPAN | 2022-10-13 00:00:00 | 2022-09-09 00:00:00 | 2022-09-30 00:00:00
[NAME] X20,000 (150KG) | 2022-10-13 00:00:00 | 2022-09-16 00:00:00
IBUPROFEN 200MG CAPS X 250 CAN- COS | 2022-10-13 00:00:00
IBUPROFEN 200MG CAPS X 250 CAN- COS | 2022-10-13 00:00:00
PENTASA 250MG CAPSULES X 240 - S | 2022-10-14 00:00:00
PENTASA 250MG CAPSULES X 240 - S | 2022-10-14 00:00:00
M AMPHET SALTS 10MG CAPS X100 PRASCO - S | 2022-10-14 00:00:00 | 2022-08-30 00:00:00
M AMPHET SALTS 20MG CAPS X100 PRASCO - S | 2022-10-14 00:00:00 | 2022-08-18 00:00:00 | 2022-08-29 00:00:00
M AMPHET SALTS 20MG CAPS X100 SANDOZ - S | 2022-10-14 00:00:00 | 2022-09-28 00:00:00
VYVANSE 20MG CAPS X 100 QLCPS, US 2X - S | 2022-10-14 00:00:00
CLARITIN D-24HR TAB BC 15CT CPN 87566641 | 2022-10-14 00:00:00
IBUPROFEN 400MG CAPS X 120 CAN- COS | 2022-10-15 00:00:00
IBUPROFEN 400MG CAPS X 120 CAN- COS | 2022-10-15 00:00:00
IBUPROFEN 400MG CAPS X 120 CAN- COS | 2022-10-16 00:00:00
IBUPROFEN 400MG CAPS X 120 CAN- COS | 2022-10-16 00:00:00
APTENSIO XR 10MG CAPSULES X 90 - S | 2022-10-17 00:00:00 | 2022-09-26 00:00:00
METHYLPHENIDATE HCL ER 20MG CAPS X90 - S | 2022-10-17 00:00:00 | 2022-09-29 00:00:00
M AMPHET SALTS 20MG CAPS X100 SANDOZ - S | 2022-10-17 00:00:00
VYVANSE 30MG CAPS X 100 QLCPS, US 2X - S | 2022-10-17 00:00:00 | 2022-09-07 00:00:00 | 2022-09-09 00:00:00
VYVANSE 30MG CAPS X 100 QLCPS, US 2X - S | 2022-10-17 00:00:00 | 2022-09-09 00:00:00 | 2022-09-22 00:00:00
CLARITIN D-24HR TAB BC 15CT CPN 87566641 | 2022-10-17 00:00:00
CLARITIN D-24HR TAB BC 15CT CPN 87566641 | 2022-10-17 00:00:00
[NAME] 10MG TAB DRUM X40,000 (150KG) | 2022-10-17 00:00:00 | 2022-09-13 00:00:00
[NAME] 10MG TAB DRUM X40,000 (150KG) | 2022-10-17 00:00:00 | 2022-09-13 00:00:00
SPD503 4MG TABS BULK EU/ROW PHZELL API | 2022-10-17 00:00:00 | 2022-09-15 00:00:00
SPD503 2MG TABS BULK EU/ROW PHZELL API | 2022-10-17 00:00:00 | 2022-09-24 00:00:00
IBUPROFEN 400MG CAPS X 120 CAN- COS | 2022-10-17 00:00:00
IBUPROFEN 400MG CAPS X 120 CAN- COS | 2022-10-17 00:00:00
VYVANSE 30MG CAPS X 100 QLCPS, US 2X - S | 2022-10-18 00:00:00 | 2022-09-08 00:00:00 | 2022-09-20 00:00:00
VYVANSE 40MG CAPS X 100 QLCPS, US 2X - S | 2022-10-18 00:00:00 | 2022-09-13 00:00:00 | 2022-09-20 00:00:00
VYVANSE 40MG CAPS X 100 QLCPS, US 2X - S | 2022-10-18 00:00:00 | 2022-09-14 00:00:00 | 2022-09-20 00:00:00
VYVANSE 40MG CAPS X 100 QLCPS, US 2X - S | 2022-10-18 00:00:00 | 2022-09-16 00:00:00
CLARITIN D-24HR TAB BC 10CT CPN 87566633 | 2022-10-18 00:00:00
IBUPROFEN 400MG CAPS X 120 CAN- COS | 2022-10-18 00:00:00
VYVANSE 50MG CAPS X 100 QLCPS, US 2X - S | 2022-10-20 00:00:00 | 2022-09-17 00:00:00 | 2022-10-05 00:00:00
M AMPHET SALTS 10MG CAPS X100 SANDOZ - S | 2022-10-20 00:00:00 | 2022-09-02 00:00:00 | 2022-10-05 00:00:00
VYVANSE 40MG CAPS X 100 QLCPS, US 2X - S | 2022-10-20 00:00:00 | 2022-09-17 00:00:00 | 2022-09-23 00:00:00
VYVANSE 40MG CAPS X 100 QLCPS, US 2X - S | 2022-10-20 00:00:00 | 2022-09-19 00:00:00 | 2022-09-26 00:00:00
VYVANSE 70MG CAPS X 100 QLCPS, US 2X - S | 2022-10-20 00:00:00
CLARITIN D-12HR TAB BC 30CT CPN 87566374 | 2022-10-20 00:00:00
CLARITIN D-24HR TAB BC 10CT CPN 87566633 | 2022-10-20 00:00:00
VYVANSE 50MG CAPS X 100 QLCPS, US 2X - S | 2022-10-21 00:00:00 | 2022-09-22 00:00:00 | 2022-09-23 00:00:00
M AMPHET SALTS 5MG CAPS X100 SANDOZ - S | 2022-10-21 00:00:00 | 2022-08-25 00:00:00 | 2022-09-06 00:00:00
M AMPHET SALTS 10MG CAPS X100 SANDOZ - S | 2022-10-21 00:00:00 | 2022-08-28 00:00:00 | 2022-09-13 00:00:00
M AMPHET SALTS 10MG CAPS X100 SANDOZ - S | 2022-10-21 00:00:00 | 2022-08-31 00:00:00 | 2022-10-03 00:00:00
M AMPHET SALTS 10MG CAPS X100 SANDOZ - S | 2022-10-21 00:00:00 | 2022-09-01 00:00:00 | 2022-09-07 00:00:00
M AMPHET SALTS 15MG CAPS X100 SANDOZ - S | 2022-10-21 00:00:00 | 2022-09-23 00:00:00
VYVANSE 50MG CAPSULES X 100 CANADA | 2022-10-21 00:00:00 | 2022-09-01 00:00:00 | 2022-09-01 00:00:00
VYVANSE 50MG CAPS X 100 QLCPS, US 2X - S | 2022-10-21 00:00:00 | 2022-09-25 00:00:00 | 2022-09-23 00:00:00
VYVANSE 50MG CAPSULES X 100 CANADA | 2022-10-21 00:00:00 | 2022-09-04 00:00:00 | 2022-09-09 00:00:00
TRILEPTAL 300MG TABLETS X 100 - S | 2022-10-21 00:00:00 | 2022-09-21 00:00:00
TEGRETOL 200MG TABLETS X 100 - S | 2022-10-21 00:00:00 | 2022-09-10 00:00:00
TRILEPTAL 600MG TABLETS X 100 - S | 2022-10-21 00:00:00 | 2022-09-23 00:00:00
CLARITIN D-24HR TAB BC 10CT CPN 87566633 | 2022-10-21 00:00:00
VYVANSE 60MG CAPS X 100 QLCPS, US 2X - S | 2022-10-24 00:00:00 | 2022-08-21 00:00:00 | 2022-09-09 00:00:00
VYVANSE 60MG CAPS X 100 QLCPS, US 2X - S | 2022-10-24 00:00:00 | 2022-09-26 00:00:00 | 2022-10-03 00:00:00
M AMPHET SALTS 10MG CAPS X100 SANDOZ - S | 2022-10-24 00:00:00
M AMPHET SALTS 15MG CAPS X100 PRASCO - S | 2022-10-24 00:00:00 | 2022-09-22 00:00:00
VYVANSE 50MG CAPSULES X 100 CANADA | 2022-10-24 00:00:00 | 2022-09-03 00:00:00 | 2022-08-31 00:00:00
ADDERALL XR 20 MG CAPSULES CANADA | 2022-10-24 00:00:00 | 2022-09-23 00:00:00 | 2022-09-26 00:00:00
AURYXIA 210MG TABLETS BOTTLE X 200 - S | 2022-10-24 00:00:00 | 2022-08-27 00:00:00 | 2022-08-25 00:00:00
SPD503 1MG TABS BULK CHEMO API JAPAN | 2022-10-24 00:00:00 | 2022-09-08 00:00:00
SPD503 3MG TABS BULK PHZELL API JAPAN | 2022-10-24 00:00:00 | 2022-09-11 00:00:00
CLARITIN D-24HR TAB BC 10CT CPN 87566633 | 2022-10-24 00:00:00
CLARITIN D-24HR TAB BC 10CT CPN 87566633 | 2022-10-24 00:00:00
VYVANSE 60MG CAPS X 100 QLCPS, US 2X - S | 2022-10-25 00:00:00 | 2022-08-23 00:00:00 | 2022-09-01 00:00:00
VYVANSE 70MG CAPS X 100 QLCPS, US 2X - S | 2022-10-25 00:00:00 | 2022-08-26 00:00:00 | 2022-09-09 00:00:00
M AMPHET SALTS 25MG CAPS X100 SANDOZ - S | 2022-10-25 00:00:00
VYVANSE 60MG CAPSULES X 100 CANADA | 2022-10-25 00:00:00 | 2022-09-22 00:00:00 | 2022-09-22 00:00:00
M AMPHET SALTS 20MG CAPS X100 PRASCO - S | 2022-10-25 00:00:00 | 2022-09-26 00:00:00
M AMPHET SALTS 25MG CAPS X100 SANDOZ - S | 2022-10-25 00:00:00 | 2022-09-26 00:00:00
CLARITIN D-24HR TAB BC 10CT CPN 87566633 | 2022-10-25 00:00:00
Vazalore (Aspirin) 325mg capsules 30ct | 2022-10-25 00:00:00
CLARITIN D-24HR TAB BC 10CT CPN 87566633 | 2022-10-26 00:00:00
VYVANSE 20MG CAPS X 100 QLCPS, US 2X - S | 2022-10-27 00:00:00
Diovan HCT 160mg/25mg Tabs x 90-S (full) | 2022-10-27 00:00:00
M AMPHET SALTS 25MG CAPS X100 PRASCO - S | 2022-10-27 00:00:00 | 2022-09-28 00:00:00
VYVANSE 70MG CAPS X 100 QLCPS, US 2X - S | 2022-10-27 00:00:00 | 2022-08-29 00:00:00 | 2022-09-09 00:00:00
TEGRETOL 200MG TABS X 60 ARGENTINA | 2022-10-27 00:00:00 | 2022-09-10 00:00:00
VYVANSE 70MG CAPSULES X 100 CANADA | 2022-10-27 00:00:00
CLARITIN D-24HR TAB BC 10CT CPN 87566633 | 2022-10-27 00:00:00
FOSRENOL 1000MG TABLETS X10 CARTON X9 -S | 2022-10-28 00:00:00 | 2022-07-22 00:00:00 | 2022-07-28 00:00:00
FOSRENOL 1000MG TABLETS X10 CARTON X9 -S | 2022-10-28 00:00:00 | 2022-08-26 00:00:00
VYVANSE 70MG CAPS X 100 QLCPS, US 2X - S | 2022-10-28 00:00:00 | 2022-08-27 00:00:00 | 2022-08-31 00:00:00
Singulair Oral Granule 4 mg | 2022-10-28 00:00:00
Singulair Oral Granule 4 mg | 2022-10-28 00:00:00
FOSRENOL 500MG TABS X45 CARTON X2 CANADA | 2022-10-28 00:00:00
FOSRENOL 750MG TABS X15 CARTON X6 CANADA | 2022-10-28 00:00:00
Singulair Oral Granule 4 mg | 2022-10-28 00:00:00
TEGRETOL 200MG TABS X 60 ARGENTINA | 2022-10-28 00:00:00 | 2022-09-29 00:00:00
VYVANSE 70MG CAPS X 100 QLCPS, US 2X - S | 2022-10-28 00:00:00
VYVANSE 70MG CAPS X 100 QLCPS, US 2X - S | 2022-10-28 00:00:00
CLARITIN D-24HR TAB BC 10CT CPN 87566633 | 2022-10-28 00:00:00
CLARITIN D-24HR TAB BC 10CT CPN 87566633 | 2022-10-28 00:00:00
AURYXIA 210MG TABLETS BOTTLE X 200 - S | 2022-10-31 00:00:00 | 2022-08-27 00:00:00 | 2022-08-02 00:00:00
AURYXIA 210MG TABLETS BOTTLE X 200 - S | 2022-10-31 00:00:00 | 2022-08-28 00:00:00 | 2022-09-09 00:00:00
AURYXIA 210MG TABLETS BOTTLE X 200 - S | 2022-10-31 00:00:00 | 2022-08-28 00:00:00 | 2022-08-05 00:00:00
CLARITIN D-24HR TAB BC 10CT CPN 87566633 | 2022-10-31 00:00:00