Spreadsheet: 75946d1276544072-compare-dates-in-several-columns-and-return-value-if-15-days-of-today-due-14-days-sample
Sheet: DRAFT

DRAFT |  |  |  |  |  |  |  | PM Step: | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6 |  | 7 |  | 8 |  | 9
Field Type (SharePoint?) Comment: | 360 |  | 360 |  | for reporting and filtering |  | Placeholder for Future (May add parent and child) | 360 | Date Field | Date Field | Date Field | Date Field | Date Field | Date Field | Date Field | Date Field | Date Field | Date Field | Date Field | Date Field | Date Field | Date Field |  | Date Field | Date Field | Date Field
Today: |  |  |  |  |  |  |  | 30 Day Schedule | -30
protect | protect | protect | protect | protect | protect | protect | protect | 60 Day Schedule | -60 | no protect |  | no protect |  | no protect |  | no protect |  | no protect |  | no protect |  | no protect | no protect | no protect |  | no protect
 |  |  |  |  |  |  |  | 90 Day Schedule | -90 |  | -87 |  | -73 |  | -66 |  | -52 |  | -45 |  | -37 |  |  | does this come from 360? | 14
 | Request ID (WO #) | WO Issue Date | Statement of Work | Procedure | Frequency | FM Region | Asset  Name | Vendor (Assigned To) | Schedule Vendor Target | Schedule Vendor Actual | [NAME]Client) Target | [NAME]Client) Actual | MOP (Get from Vendor) Target | MOP (Get from Vendor) Actual | MOP  (Internal Review & Approve) Target | MOP  (Internal Review & Approve) Actual | MOP (Client Approval) Target | MOP (Client Approval) Actual | Homer (Switch) Target | Homer (Switch) Actual | Change Control  (Data Centers) Target | Change Control  (Data Centers) Actual | Perform Work Target | Perform Work Actual | Report Due Target | Report Due Actual | Due in 14 Days | Expected Result
Test  C | 5 | 2009-10-04 00:00:00 |  |  | QTR |  |  | VDR 5 |  | 2009-11-01 00:00:00 |  | 2009-11-01 00:00:00 |  | 2009-11-22 00:00:00 |  | 2009-11-27 00:00:00 |  | 2009-12-02 00:00:00 |  | 2009-12-17 00:00:00 |  | 2009-12-26 00:00:00 | 2010-02-01 00:00:00 | 2010-01-31 00:00:00 |  | 2010-02-20 00:00:00 |  | 0
Test  C | 6 | 2009-11-01 00:00:00 |  |  | SEMIANNU |  |  | VDR 8 |  | 2009-11-10 00:00:00 |  | 2009-11-11 00:00:00 |  | 2009-12-15 00:00:00 |  | 2009-12-22 00:00:00 |  | 2010-01-05 00:00:00 |  | 2010-01-14 00:00:00 |  | 2010-01-20 00:00:00 | 2010-03-01 00:00:00 | 2010-03-01 00:00:00 |  | 2010-03-15 00:00:00 |  | 0
Test  F | 10 | 2009-11-15 00:00:00 |  |  | QTR |  |  | VDR 4 |  | 2009-12-14 00:00:00 |  | 2009-12-15 00:00:00 |  | 2009-12-20 00:00:00 |  | 2010-01-01 00:00:00 |  | 2010-02-22 00:00:00 |  | 2010-01-29 00:00:00 |  | 2010-02-06 00:00:00 | 2010-03-15 00:00:00 | 2010-03-14 00:00:00 |  | 2010-03-15 00:00:00 |  | 0
Test  E | 9 | 2010-05-02 00:00:00 |  |  | QTR |  |  | VDR 1 |  | 2010-01-01 00:00:00 |  | 2010-01-03 00:00:00 |  | 2010-01-15 00:00:00 |  | 2010-01-28 00:00:00 |  | 2010-02-10 00:00:00 | 2010-02-10 00:00:00 | 2010-02-10 00:00:00 |  | 2010-02-15 00:00:00 | 2010-04-01 00:00:00 | 2010-03-31 00:00:00 |  | 2010-04-08 00:00:00 |  | 0
Test  J | 23 | 2010-04-16 00:00:00 |  |  | QTR |  |  | VDR 4 |  | 2010-01-31 00:00:00 |  | 2010-02-03 00:00:00 |  | 2010-02-18 00:00:00 |  | 2010-02-24 00:00:00 |  | 2010-03-08 00:00:00 |  | 2010-03-16 00:00:00 |  | 2010-03-25 00:00:00 | 2010-05-01 00:00:00 | 2010-04-30 00:00:00 |  | 2010-05-14 00:00:00 |  | 0
Test  H | 17 | 2009-12-02 00:00:00 |  |  | QTR |  |  | VDR 5 |  | 2010-04-01 00:00:00 |  | 2010-04-01 00:00:00 |  | 2010-04-19 00:00:00 |  | 2010-04-22 00:00:00 |  | 2010-05-01 00:00:00 |  | 2010-05-17 00:00:00 |  | 2010-05-22 00:00:00 | 2010-07-01 00:00:00 |  |  | 2010-04-14 00:00:00 |  | 0
Test  G | 16 | 2010-01-05 00:00:00 |  |  | QTR |  |  | VDR 5 |  | 2010-05-03 00:00:00 |  | 2010-05-06 00:00:00 |  | 2010-05-19 00:00:00 |  | 2010-05-27 00:00:00 |  | 2010-06-09 00:00:00 |  |  |  |  | 2010-08-01 00:00:00 |  |  |  |  | 2
Test  J | 22 | 2010-04-03 00:00:00 |  |  | QTR |  |  | VDR 1 |  | 2010-05-01 00:00:00 |  | 2010-05-08 00:00:00 |  | 2010-05-20 00:00:00 |  | 2010-05-27 00:00:00 |  | 2010-06-09 00:00:00 |  |  |  |  | 2010-08-01 00:00:00 |  |  |  |  | 2
Test  C | 7 | 2010-04-17 00:00:00 |  |  | SEMIANNU |  |  | VDR 2 |  | 2010-05-05 00:00:00 |  | 2010-05-15 00:00:00 |  | 2010-05-29 00:00:00 |  | 2010-06-05 00:00:00 |  | 2010-06-17 00:00:00 |  |  |  |  | 2010-08-10 00:00:00 |  |  |  |  | 1
Test  G | 15 | 2010-04-18 00:00:00 |  |  | QTR |  |  | VDR 1 |  | 2010-05-18 00:00:00 |  | 2010-05-21 00:00:00 |  | 2010-06-03 00:00:00 |  | 2010-06-10 00:00:00 |  |  |  |  |  |  | 2010-08-16 00:00:00 |  |  |  |  | 1
Test  I | 19 | 2010-04-18 00:00:00 |  |  | QTR |  |  | VDR 5 |  | 2010-05-18 00:00:00 |  | 2010-05-20 00:00:00 |  | 2010-06-05 00:00:00 |  | 2010-06-10 00:00:00 |  |  |  |  |  |  | 2010-08-16 00:00:00 |  |  |  |  | 1
Test  I | 21 | 2010-04-18 00:00:00 |  |  | YR |  |  | VDR 6 |  | 2010-05-20 00:00:00 |  | 2010-05-21 00:00:00 |  | 2010-06-02 00:00:00 |  | 2010-06-10 00:00:00 |  |  |  |  |  |  | 2010-08-16 00:00:00 |  |  |  |  | 1
Test  K | 24 | 2010-04-18 00:00:00 |  |  | QTR |  |  | VDR 1 |  | 2010-05-16 00:00:00 |  | 2010-05-21 00:00:00 |  | 2010-06-02 00:00:00 |  | 2010-06-10 00:00:00 |  |  |  |  |  |  | 2010-08-16 00:00:00 |  |  |  |  | 1
Test  D | 8 | 2010-05-02 00:00:00 |  |  | QTR |  |  | VDR 1 |  | 2010-05-31 00:00:00 |  | 2010-06-04 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2010-08-30 00:00:00 |  |  |  |  | 2
Test  I | 20 | 2010-05-02 00:00:00 |  |  | SEMIANNU |  |  | VDR 2 |  | 2010-05-05 00:00:00 |  | 2010-06-04 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2010-08-30 00:00:00 |  |  |  |  | 2
Test  B | 3 | 2010-05-08 00:00:00 |  |  | SEMIANNU |  |  | VDR 7 |  | 2010-06-01 00:00:00 |  | 2010-06-06 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2010-09-01 00:00:00 |  |  |  |  | 2
Test  A | 2 | 2010-06-03 00:00:00 |  |  | SEMIANNU |  |  | VDR 7 |  | 2010-05-18 00:00:00 |  | 2010-06-20 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2010-09-15 00:00:00 |  |  |  |  | 0
Test  A | 4 | 2010-06-03 00:00:00 |  |  | YR |  |  | VDR 3 |  | 2010-07-01 00:00:00 |  | 2010-07-06 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2010-10-01 00:00:00 |  |  |  |  | 0
Test  D | 11 | 2010-05-04 00:00:00 |  |  | SEMIANNU |  |  | VDR 2 |  | 2010-06-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2010-10-01 00:00:00 |  |  |  |  | 0
Test  G | 14 | 2010-01-05 00:00:00 |  |  | QTR |  |  | VDR 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-10-01 00:00:00 |  |  |  |  | 0
Test  H | 18 | 2010-06-03 00:00:00 |  |  | SEMIANNU |  |  | VDR 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-10-01 00:00:00 |  |  |  |  | 0
Test  A | 1 | 2010-04-19 00:00:00 |  |  | SEMIANNU |  |  | VDR 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-10-15 00:00:00 |  |  |  |  | 0
Test  E | 13 | 2010-04-18 00:00:00 |  |  | YR |  |  | VDR 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-10-15 00:00:00 |  |  |  |  | 0
Test  L | 25 | 2010-06-03 00:00:00 |  |  | QTR |  |  | VDR 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-10-15 00:00:00 |  |  |  |  | 0
Test  M | 26 | 2010-06-03 00:00:00 |  |  | QTR |  |  | VDR 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-10-15 00:00:00 |  |  |  |  | 0
Test  D | 12 | 2010-08-03 00:00:00 |  |  | YR |  |  | VDR 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-10-15 00:00:00 |  |  |  |  | 0