Spreadsheet: 141617d1329370043-need-a-wildcard-solution-in-an-if-statement-wo-sch-excel-2003
Sheet: WOJ

WORKOVER AVAILABILTY
 |  | ENTER WO DATE, *Include Year |  |  |  | 2012-01-03 00:00:00
SEARCH | NIGHT |  |  |  |  |  |  |  |  | REFUSAL DATES  *Enter the third refusal date in the MANUAL OVERRIDE column to reset the LAST WO |  |  | LAST WO |  |  |  |  |  | NOT |  |  | SEARCH | 2012-01-01 00:00:00 | 2012-01-02 00:00:00 | 2012-01-03 00:00:00 | 2012-01-04 00:00:00 | 2012-01-05 00:00:00 | 2012-01-06 00:00:00 | 2012-01-07 00:00:00 | 2012-01-08 00:00:00 | 2012-01-09 00:00:00 | 2012-01-10 00:00:00 | 2012-01-11 00:00:00 | 2012-01-12 00:00:00 | 2012-01-13 00:00:00 | 2012-01-14 00:00:00 | 2012-01-15 00:00:00 | 2012-01-16 00:00:00 | 2012-01-17 00:00:00 | 2012-01-18 00:00:00 | 2012-01-19 00:00:00 | 2012-01-20 00:00:00 | 2012-01-21 00:00:00 | 2012-01-22 00:00:00 | 2012-01-23 00:00:00 | 2012-01-24 00:00:00 | 2012-01-25 00:00:00 | 2012-01-26 00:00:00 | 2012-01-27 00:00:00 | 2012-01-28 00:00:00 | 2012-01-29 00:00:00 | 2012-01-30 00:00:00 | 2012-01-31 00:00:00
DATE | ONLY |  |  |  |  | REQUESTED | REQUESTED |  |  |  |  |  | MANUAL |  |  |  |  |  | ON WO |  |  | DATE | s | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T
2012-01-03 00:00:00 |  | NAME | EMP # | SEN# | QUAL | BASES | DAYS | CONTACT# | ALT CONT# | FIRST | SECOND | THIRD | OVERRIDE | OCT | NOV | DEC | JAN | LAST WO | LIST | EMP# | NAME | 2012-01-03 00:00:00 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
A | NiO | BILLY | 480 | 1 | 350407 | All | All | [PHONE] | [PHONE] |  |  | 2012-01-31 00:00:00 | 2012-01-31 00:00:00 | 2011-10-29 00:00:00 | 2011-11-29 00:00:00 | 2011-12-29 00:00:00 | 2012-01-26 00:00:00 | 2012-01-31 00:00:00 | X | 480 | BILLY | A |  |  | A | A | A | A | A | A | A | A | A | A |  |  |  |  |  |  |  |  | A | A | A | A | A
 |  | JACK | 485 | 2 | 350407 | All | Fri. Sat | [PHONE] | [PHONE] |  |  |  | 2012-01-08 00:00:00 | 2011-10-26 00:00:00 |  | 2011-12-24 00:00:00 | 2012-01-06 00:00:00 | 2012-01-08 00:00:00 |  | 485 | JACK |  | A | A |  |  |  |  | A | A | A | A | A | A |  |  |  |  |  |  |  | A | A | A | A | A | A | A
 |  | [NAME] | 500 | 3 | 350 | All | Prefer Days | [PHONE] | [PHONE] |  |  |  |  | 2011-10-21 00:00:00 | 2011-11-21 00:00:00 | 2011-12-21 00:00:00 | 2012-01-29 00:00:00 | 2012-01-29 00:00:00 |  | 500 | [NAME] |  | A | A |  |  | A |  |  |  |  |  |  |  | A | A | A | A | A | A | A |  |  |  |  |  |  |  | A | A |  | A | A
A |  | FRED | 505 | 4 | 350 | All | All | [PHONE] | [PHONE] |  |  |  |  | 2011-10-21 00:00:00 | 2011-11-21 00:00:00 | 2011-12-21 00:00:00 | 2012-01-30 00:00:00 | 2012-01-30 00:00:00 |  | 505 | FRED | A | A |  | A | A | A |  |  |  |  |  |  |  | A | A | A | A | A | A | A |  |  |  |  |  |  |  | A | A | A |  | A
 |  | [NAME] | 510 | 5 | 350 | All | All | [PHONE] | [PHONE] |  |  |  | 2011-12-18 00:00:00 | 2011-10-14 00:00:00 | 2011-11-14 00:00:00 | 2011-12-14 00:00:00 |  | 2011-12-18 00:00:00 | X | 510 | [NAME] |  | A |  |  |  |  | A | A | A | A | A | A | A |  |  |  |  |  |  |  | A | A | A | A | A | A | A
A |  | CARL | 515 | 6 | 350407 | All | All | [PHONE] | [PHONE] |  |  |  | 2011-12-16 00:00:00 |  |  | 2011-12-23 00:00:00 |  | 2011-12-23 00:00:00 |  | 515 | CARL | A | A | A | A | A | A | A | A | A | A | A | A | A |  |  |  |  |  |  |  | A | A | A | A | A | A | A
A | NiO | DON | 520 | 7 | 350 | All | All | [PHONE] | [PHONE] |  |  |  |  | 2011-10-20 00:00:00 | 2011-11-16 00:00:00 | 2011-12-02 00:00:00 |  | 2011-12-02 00:00:00 |  | 520 | DON | A | A |  | A | A | A |  |  |  |  |  |  |  | A | A | A | A | A | A | A |  |  |  |  |  |  |  | A | A | A | A | A
A | NiO | FRANK | 525 | 8 | 350 | All | All | [PHONE] | [PHONE] |  |  |  | 2011-05-08 00:00:00 |  |  | 2011-12-02 00:00:00 | 2012-01-04 00:00:00 | 2012-01-04 00:00:00 |  | 525 | FRANK | A | A |  | A |  | A |  |  |  |  |  |  |  | A | A | A | A | A | A | A |  |  |  |  |  |  |  | A | A | A | A | A
 | LY
 | CK