Spreadsheet: 42227d1240839561-counting-dates-within-a-specific-range-we-blank-template-1-v3
Sheet: A Client

A Client | Company_Name - Office_Name - Weekend XX (XX/XX/XX - XX/XX/XX)
CLIENT | A Client | WORKSITE | [NAME]
PURCHASE ORDER NO | 12345 | ACCESS @ | Piccadilly Station
REQUESTER | [NAME] | DEPOT | [NAME]
QS | [NAME] | WORK DETAILS | Re-Rail
SHIFT(S) OFFERED | 4 | SHIFT(S) OFFERED ON | 2009-04-27 00:00:00 | 10:30:00
SHIFT(S) FILLED | 3 | P/O RECEIVED ON | 2009-04-27 00:00:00 | 14:30:00
SHIFT(S) CANCELLED | 1 | SHIFT(S) CANCELLED ON | 2009-04-28 00:00:00 | 09:30:00
DAY / TIME | JOB TYPE | CANDIDATE | Mobile Number | Pay Rate | Inv Rate | Pay Method | TRC | Hrs | Pay | Invoice
Sat 2300 - Sun 1100 | PTS | Name 1 | [NAME] | 8 | 16 | LTD | OT2 | 12 | 96 | 192
 | UTF PTS | Name 2 | [NAME] | 8 | 16 | LTD | OT2 | 0 | 0 | 0
 | CANCELLED PTS | Name 3 | [NAME] | 8 | 16 | LTD | OT2 | 0 | 0 | 0
 | DNG PTS | Name 4 | [NAME] | 8 | 16 | LTD | OT2 | 0 | 0 | 0
 | SITE CONTACT: | [NAME] | [NAME]
CLIENT | A Client | WORKSITE
MRF |  | ACCESS @
REQUESTER |  | DEPOT
QS |  | WORK DETAILS
DAY / TIME | JOB TYPE | CANDIDATE | Mobile Number | Pay Rate | Inv Rate | Pay Method | TRC | Hrs | Pay | Invoice
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 | SITE CONTACT:
CLIENT | A Client | WORKSITE
MRF |  | ACCESS @
REQUESTER |  | DEPOT
QS |  | WORK DETAILS
DAY / TIME | JOB TYPE | CANDIDATE | Mobile Number | Pay Rate | Inv Rate | Pay Method | TRC | Hrs | Pay | Invoice
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 | SITE CONTACT:
CLIENT | A Client | WORKSITE
MRF |  | ACCESS @
REQUESTER |  | DEPOT
QS |  | WORK DETAILS
DAY / TIME | JOB TYPE | CANDIDATE | Mobile Number | Pay Rate | Inv Rate | Pay Method | TRC | Hrs | Pay | Invoice
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 | SITE CONTACT:
CLIENT | A Client | WORKSITE
MRF |  | ACCESS @
REQUESTER |  | DEPOT
QS |  | WORK DETAILS
DAY / TIME | JOB TYPE | CANDIDATE | Mobile Number | Pay Rate | Inv Rate | Pay Method | TRC | Hrs | Pay | Invoice
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 | SITE CONTACT:
CLIENT | A Client | WORKSITE
MRF |  | ACCESS @
REQUESTER |  | DEPOT
QS |  | WORK DETAILS
DAY / TIME | JOB TYPE | CANDIDATE | Mobile Number | Pay Rate | Inv Rate | Pay Method | TRC | Hrs | Pay | Invoice
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 | SITE CONTACT:
CLIENT | A Client | WORKSITE
MRF |  | ACCESS @
REQUESTER |  | DEPOT
QS |  | WORK DETAILS
DAY / TIME | JOB TYPE | CANDIDATE | Mobile Number | Pay Rate | Inv Rate | Pay Method | TRC | Hrs | Pay | Invoice
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 | SITE CONTACT:
CLIENT | A Client | WORKSITE
MRF |  | ACCESS @
REQUESTER |  | DEPOT
QS |  | WORK DETAILS
DAY / TIME | JOB TYPE | CANDIDATE | Mobile Number | Pay Rate | Inv Rate | Pay Method | TRC | Hrs | Pay | Invoice
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 | SITE CONTACT:
CLIENT | A Client | WORKSITE
MRF |  | ACCESS @
REQUESTER |  | DEPOT
QS |  | WORK DETAILS
DAY / TIME | JOB TYPE | CANDIDATE | Mobile Number | Pay Rate | Inv Rate | Pay Method | TRC | Hrs | Pay | Invoice
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 | SITE CONTACT:
CLIENT | A Client | WORKSITE
MRF |  | ACCESS @
REQUESTER |  | DEPOT
QS |  | WORK DETAILS
DAY / TIME | JOB TYPE | CANDIDATE | Mobile Number | Pay Rate | Inv Rate | Pay Method | TRC | Hrs
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 | SITE CONTACT:
CLIENT | A Client | WORKSITE
MRF |  | ACCESS @
REQUESTER |  | DEPOT
QS |  | WORK DETAILS
DAY / TIME | JOB TYPE | CANDIDATE | Mobile Number | Pay Rate | Inv Rate | Pay Method | TRC | Hrs | Pay | Invoice
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 | SITE CONTACT:
CLIENT | A Client | WORKSITE
MRF |  | ACCESS @
REQUESTER |  | DEPOT
QS |  | WORK DETAILS
DAY / TIME | JOB TYPE | CANDIDATE | Mobile Number | Pay Rate | Inv Rate | Pay Method | TRC | Hrs | Pay | Invoice
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 | SITE CONTACT: