Spreadsheet: 194989d1353386504-how-to-count-cell-values-based-on-2-conditions-example_excel_help
Sheet: Chandler

Shift Start | Shift End | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Date Shift Vacated |  | Shift Start | Shift End | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Date Shift Vacated
11am | 8pm |  |  | 1 | 1 | 1 | 1 | 1 | 2012-07-05 00:00:00 |  | 630am | 330pm | 1 | 1 |  |  | 1 | 1 | 1 | 2012-07-07 00:00:00
8am | 12pm | 1 | 1 | 1 | 1 | 1 |  | 1 | 2012-07-09 00:00:00 |  | 11am | 10pm | 1 |  | 1 | 1 |  |  | 1 | 2012-08-01 00:00:00
12pm | 9pm | 1 |  |  | 1 | 1 | 1 | 1 | 2012-07-13 00:00:00 |  | 2pm | 11pm | 1 | 1 | 1 |  |  | 1 | 1 | 2012-08-04 00:00:00
11am | 8pm |  |  | 1 | 1 | 1 | 1 | 1 | 2012-07-15 00:00:00 |  | 2pm | 11pm | 1 | 1 | 1 |  |  | 1 | 1 | 2012-08-06 00:00:00
12pm- | 11pm | 1 | 1 | 1 | 1 |  |  |  | 2012-07-15 00:00:00 |  | 230pm | 11pm |  |  | 1 | 1 | 1 | 1 | 1 | 2012-08-07 00:00:00
945am | 630pm |  | 1 | 1 | 1 |  | 1 | 1 | 2012-07-17 00:00:00 |  | 230pm | 11pm |  |  | 1 | 1 | 1 | 1 | 1 | 2012-08-07 00:00:00
6am | 10am | 1 | 1 | 1 | 1 | 1 |  | 1 | 2012-07-18 00:00:00 |  | 18:00:00 | 23:00:00 |  | 1 | 1 | 1 | 1 | 1 |  | 2012-08-16 00:00:00
1030am | 730pm |  | 1 | 1 | 1 | 1 | 1 |  | 2012-07-19 00:00:00 |  | 8am | 5pm |  | 1 | 1 | 1 | 1 | 1 |  | 2012-08-23 00:00:00
6pm | 11pm | 1 | 1 |  |  | 1 | 1 | 1 | 2012-07-20 00:00:00 |  | 2pm | 1030pm | 1 | 1 |  | 1 |  | 1 | 1 | 2012-09-05 00:00:00
230pm | 11pm | 1 | 1 | 1 | 1 |  |  | 1 | 2012-07-21 00:00:00 |  | 930am | 630pm | 1 |  |  | 1 | 1 | 1 | 1 | 2012-08-31 00:00:00
2pm | 1030pm |  | 1 | 1 | 1 |  | 1 | 1 | 2012-07-21 00:00:00 |  | 930am | 630pm | 1 |  |  | 1 | 1 | 1 | 1 | 2012-09-02 00:00:00
230pm | 1115pm | 1 | 1 |  |  | 1 | 1 | 1 | 2012-07-21 00:00:00 |  | 555am | 225pm | 1 | 1 |  |  | 1 | 1 | 1 | 2012-09-08 00:00:00
2pm | 1045pm | 1 | 1 |  |  | 1 | 1 | 1 | 2012-07-22 00:00:00 |  | 2pm | 1030pm | 1 | 1 |  | 1 |  | 1 | 1 | 2012-09-07 00:00:00
1030am | 930pm |  | 1 | 1 |  | 1 | 1 |  | 2012-07-23 00:00:00 |  | 8am | 5pm |  | 1 | 1 | 1 | 1 | 1 |  | 2012-09-18 00:00:00
10am | 7pm |  |  | 1 | 1 | 1 | 1 | 1 | 2012-07-24 00:00:00 |  | 9am | 545pm |  | 1 | 1 | 1 | 1 | 1 |  | 2012-09-20 00:00:00
9am | 6pm |  | 1 | 1 | 1 | 1 | 1 |  | 2012-07-25 00:00:00 |  | 630am | 330pm | 1 | 1 |  |  | 1 | 1 | 1 | 2012-09-27 00:00:00
2pm | 1045pm |  | 1 | 1 |  | 1 | 1 | 1 | 2012-07-27 00:00:00 |  | 8am | 5pm |  | 1 | 1 | 1 | 1 | 1 |  | 2012-09-30 00:00:00
10am | 9pm | 1 |  |  | 1 |  | 1 | 1 | 2012-08-01 00:00:00 |  | 2pm | 1030pm | 1 | 1 |  | 1 |  | 1 | 1 | 2012-10-01 00:00:00
7am | 6pm | 1 | 1 |  |  |  | 1 | 1 | 2012-08-17 00:00:00 |  | 930am | 830pm | 1 |  |  | 1 | 1 |  | 1 | 2012-10-05 00:00:00
14:30:00 | 23:00:00 |  |  | 1 | 1 |  |  | 1 | 2012-08-16 00:00:00 |  | 11am | 10pm |  | 1 | 1 |  | 1 | 1 |  | 2012-10-12 00:00:00
11am | 10pm | 1 |  |  | 1 | 1 |  | 1 | 2012-08-26 00:00:00 |  | 10am | 7pm |  | 1 | 1 | 1 | 1 | 1 |  | 2012-09-17 00:00:00
230pm | 11pm | 1 | 1 | 1 |  |  | 1 | 1 | 2012-08-24 00:00:00 |  | 630am | 315pm |  | 1 | 1 |  | 1 | 1 | 1 | 2012-10-19 00:00:00
11am | 8pm | 1 | 1 |  |  | 1 | 1 | 1 | 2012-08-27 00:00:00 |  | 10am | 7pm | 1 | 1 | 1 | 1 |  |  | 1 | 2012-10-24 00:00:00
11am | 8pm |  |  | 1 | 1 | 1 | 1 | 1 | 2012-09-01 00:00:00 |  | 9am | 545pm |  | 1 | 1 | 1 | 1 | 1 |  | 2012-10-26 00:00:00
11am | 8pm |  |  | 1 | 1 | 1 | 1 | 1 | 2012-09-01 00:00:00
630am | 3pm |  | 1 | 1 | 1 | 1 | 1 |  | 2012-09-04 00:00:00
2pm | 1045pm |  | 1 | 1 |  | 1 | 1 | 1 | 2012-09-09 00:00:00
2pm | 1045pm | 1 | 1 |  |  | 1 | 1 | 1 | 2012-09-09 00:00:00
230pm | 11pm | 1 | 1 | 1 |  |  | 1 | 1 | 2012-09-09 00:00:00
11am | 8pm | 1 | 1 | 1 | 1 | 1 |  |  | 2012-09-10 00:00:00
2pm | 11pm | 1 | 1 | 1 | 1 | 1 |  |  | 2012-09-09 00:00:00
9am | 6pm |  | 1 | 1 | 1 | 1 | 1 |  | 2012-09-10 00:00:00
630am | 530pm | 1 | 1 |  | 1 | 1 |  |  | 2012-09-14 00:00:00
12pm | 9pm | 1 |  |  | 1 | 1 | 1 | 1 | 2012-09-15 00:00:00
12pm | 11pm |  | 1 | 1 |  |  | 1 | 1 | 2012-09-14 00:00:00
1030am | 930pm |  |  | 1 | 1 |  | 1 | 1 | 2012-09-15 00:00:00
1030am | 930pm |  | 1 | 1 |  | 1 | 1 |  | 2012-09-21 00:00:00
230pm | 11pm | 1 | 1 | 1 |  |  | 1 | 1 | 2012-09-17 00:00:00
555am | 225pm | 1 | 1 |  | 1 | 1 |  | 1 | 2012-09-24 00:00:00
12pm | 9pm | 1 |  |  | 1 | 1 | 1 | 1 | 2012-10-01 00:00:00
10am | 7pm |  |  | 1 | 1 | 1 | 1 | 1 | 2012-10-05 00:00:00
11am | 10pm | 1 |  |  | 1 | 1 |  | 1 | 2012-10-06 00:00:00
630am | 530am |  |  | 1 | 1 |  | 1 | 1 | 2012-10-08 00:00:00
9am | 8pm |  | 1 | 1 |  | 1 | 1 |  | 2012-10-19 00:00:00
230pm | 11pm | 1 | 1 |  | 1 |  |  |  | 2012-10-25 00:00:00
555am | 225pm | 1 | 1 |  |  | 1 | 1 | 1 | 2012-10-27 00:00:00
2pm | 1045pm |  | 1 | 1 |  | 1 | 1 | 1 | 2012-10-27 00:00:00
10am | 7pm |  |  | 1 | 1 | 1 | 1 | 1 | 2012-10-27 00:00:00
555am | 225pm | 1 | 1 |  | 1 | 1 |  | 1 | 2012-11-01 00:00:00
2pm | 11pm |  | 1 | 1 | 1 | 1 | 1 |  | 2012-10-24 00:00:00
11am | 8pm | 1 | 1 |  |  | 1 | 1 | 1 | 2012-11-02 00:00:00
12pm | 11pm | 1 | 1 |  |  | 1 | 1 |  | 2012-11-02 00:00:00
2pm | 11pm |  | 1 | 1 |  | 1 |  | 1 | 2012-11-13 00:00:00
2pm | 1045pm |  | 1 | 1 |  | 1 | 1 | 1 | 2012-11-13 00:00:00
10am | 7pm |  |  | 1 | 1 | 1 | 1 | 1 | 2012-11-13 00:00:00
1030am | 930pm |  |  | 1 | 1 |  | 1 | 1 | 2012-11-14 00:00:00
12pm | 11pm |  | 1 | 1 |  | 1 | 1 |  | 2012-11-17 00:00:00
9am | 545pm | 1 | 1 |  |  | 1 | 1 | 1 | 2012-11-18 00:00:00