Spreadsheet: 744619d1629355377-countifs-values-between-2-dates-labour-schedule
Sheet: Availability

 |  |  |  |  | June
 | NAME | PAYROLL NO | POSITION | ZONE | 7/06/2021 | 8/06/2021 | 9/06/2021 | 10/06/2021 | 11/06/2021 | 12/06/2021 | 13/06/2021 | 14/06/2021 | 15/06/2021 | 16/06/2021 | 17/06/2021 | 18/06/2021 | 19/06/2021 | 20/06/2021 | 21/06/2021 | 22/06/2021 | 23/06/2021 | 24/06/2021 | 25/06/2021 | 26/06/2021 | 27/06/2021 | 28/06/2021 | 29/06/2021 | 30/06/2021 | 1/07/2021 | 2/07/2021 | 3/07/2021 | 4/07/2021 | 5/07/2021 | 6/07/2021 | 7/07/2021 | 8/07/2021 | 9/07/2021 | 10/07/2021 | 11/07/2021 | 12/07/2021 | 13/07/2021 | 14/07/2021 | 15/07/2021 | 16/07/2021 | 17/07/2021 | 18/07/2021 | 19/07/2021 | 20/07/2021 | 21/07/2021 | 22/07/2021 | 23/07/2021 | 24/07/2021 | 25/07/2021 | 26/07/2021 | 27/07/2021 | 28/07/2021 | 29/07/2021 | 30/07/2021 | 31/07/2021 | 1/08/2021 | 2/08/2021 | 3/08/2021 | 4/08/2021 | 5/08/2021 | 6/08/2021 | 7/08/2021 | 8/08/2021 | 9/08/2021 | 10/08/2021 | 11/08/2021 | 12/08/2021 | 13/08/2021 | 14/08/2021 | 15/08/2021 | 16/08/2021 | 17/08/2021 | 18/08/2021 | 19/08/2021 | 20/08/2021 | 21/08/2021 | 22/08/2021 | 23/08/2021 | 24/08/2021 | 25/08/2021 | 26/08/2021 | 27/08/2021 | 28/08/2021 | 29/08/2021 | 30/08/2021 | 31/08/2021 | 1/09/2021 | 2/09/2021 | 3/09/2021 | 4/09/2021 | 5/09/2021 | 6/09/2021 | 7/09/2021 | 8/09/2021 | 9/09/2021 | 10/09/2021 | 11/09/2021 | 12/09/2021 | 13/09/2021 | 14/09/2021 | 15/09/2021 | 16/09/2021 | 17/09/2021 | 18/09/2021 | 19/09/2021 | 20/09/2021 | 21/09/2021 | 22/09/2021 | 23/09/2021 | 24/09/2021 | 25/09/2021 | 26/09/2021 | 27/09/2021 | 28/09/2021 | 29/09/2021 | 30/09/2021 | 1/10/2021 | 2/10/2021 | 3/10/2021 | 4/10/2021 | 5/10/2021 | 6/10/2021 | 7/10/2021 | 8/10/2021 | 9/10/2021 | 10/10/2021 | 11/10/2021 | 12/10/2021 | 13/10/2021 | 14/10/2021 | 15/10/2021 | 16/10/2021 | 17/10/2021 | 18/10/2021 | 19/10/2021 | 20/10/2021 | 21/10/2021 | 22/10/2021 | 23/10/2021 | 24/10/2021 | 25/10/2021 | 26/10/2021 | 27/10/2021 | 28/10/2021 | 29/10/2021 | 30/10/2021 | 31/10/2021 | 1/11/2021 | 2/11/2021 | 3/11/2021 | 4/11/2021 | 5/11/2021 | 6/11/2021 | 7/11/2021 | 8/11/2021 | 9/11/2021 | 10/11/2021 | 11/11/2021 | 12/11/2021 | 13/11/2021 | 14/11/2021 | 15/11/2021 | 16/11/2021 | 17/11/2021 | 18/11/2021 | 19/11/2021 | 20/11/2021 | 21/11/2021 | 22/11/2021 | 23/11/2021 | 24/11/2021 | 25/11/2021 | 26/11/2021 | 27/11/2021 | 28/11/2021 | 29/11/2021 | 30/11/2021 | 1/12/2021 | 2/12/2021 | 3/12/2021 | 4/12/2021 | 5/12/2021 | 6/12/2021 | 7/12/2021 | 8/12/2021 | 9/12/2021 | 10/12/2021 | 11/12/2021 | 12/12/2021 | 13/12/2021 | 14/12/2021 | 15/12/2021 | 16/12/2021 | 17/12/2021 | 18/12/2021 | 19/12/2021 | 20/12/2021 | 21/12/2021 | 22/12/2021 | 23/12/2021 | 24/12/2021 | 25/12/2021 | 26/12/2021 | 27/12/2021 | 28/12/2021 | 29/12/2021 | 30/12/2021 | 31/12/2021 | 1/01/2022 | 2/01/2022 | 3/01/2022 | 4/01/2022 | 5/01/2022 | 6/01/2022 | 7/01/2022 | 8/01/2022 | 9/01/2022 | 10/01/2022 | 11/01/2022 | 12/01/2022 | 13/01/2022 | 14/01/2022 | 15/01/2022 | 16/01/2022 | 17/01/2022 | 18/01/2022 | 19/01/2022 | 20/01/2022 | 21/01/2022 | 22/01/2022 | 23/01/2022 | 24/01/2022 | 25/01/2022 | 26/01/2022 | 27/01/2022 | 28/01/2022 | 29/01/2022 | 30/01/2022
 | [NAME] | 7024347 | Painter | A & B
 | [NAME] | 7030036 | Painter | A & B
 | [NAME] | 7023818 | [NAME] | CYDC
 | [NAME] | 7030056 | Electrician | A & B
 | [NAME] | 7024425 | [NAME] | A & B
 | [NAME] | 7024317 | Plumber | TCC
 | [NAME] | 7029915 | [NAME] | A & B
 | Bradley Toombes | 7030038 | Electrician | A & B
 | Brent Brazao | 7023814 | [NAME] | TCC
 | [NAME] | 7030039 | [NAME] | A & B
 | [NAME] | 6006091 | [NAME] | AYR
 | [NAME] | 7029938 | [NAME] | A & B
 | [NAME] | 6001181 | [NAME] | PI
 | [NAME] | 6000529 | [NAME] | A & B
 | [NAME] | 6004733 | [NAME] | CT
 | [NAME] | 7020625 | [NAME] | TCC
 | [NAME] | 5003687 | [NAME] | CT
 | [NAME] | 7020163 | [NAME] | A & B
 | [NAME] | 7024325 | Painter | TCC
 | [NAME] | 7024099 | App Plumber | A & B
 | Hayden Barr | 7029459 | [NAME] | A & B
 | [NAME] | 5003643 | [NAME] | ING
 | [NAME] | 7020477 | [NAME] | TCC
 | [NAME] | 7024121 | Plumber | A & B
 | [NAME] | 6003723 | [NAME] | CT
 | [NAME] | 7030046 | [NAME] | A & B
 | [NAME] | 7024424 | [NAME] | A & B
 | [NAME] | 7024064 | [NAME] | A & B
 | [NAME] | 6004604 | [NAME] | HSG
 | Keegan Faulks | 7024403 | App Painter | A & B
 | [NAME] | 5003614 | [NAME] | CT
 | [NAME] | 5074018 | [NAME] | AYR
 | [NAME] | 6009793 | Plumber | A & B
 | [NAME] | 6004256 | [NAME] | TCC
 | [NAME] | 6002803 | Electrician | TCC
 | [NAME] | 7029219 | [NAME] | A & B
 | [NAME] | 7030048 | Electrician | A & B
 | [NAME] | 7030049 | Painter | A & B
 | [NAME] | 7030051 | Electrician | A & B
 | [NAME] | 6010168 | [NAME] | A & B
 | [NAME] | 6007063 | [NAME] | A & B
 | [NAME] | 7030054 | [NAME] | A & B
 | [NAME] | 6009261 | [NAME] | PI
 | [NAME] | 6007031 | [NAME] | CAP
 | [NAME] | 6009916 | [NAME] | PI
 | Samantha Cremen | 7029896 | Electrician | A & B
 | [NAME] |  | Painter | A & B
 | [NAME] | 7029935 | App Painter | A & B
 | [NAME] | 7029916 | [NAME] | A & B
 | [NAME] | 5047348 | Electrician | CT
 | [NAME] | 6008351 | [NAME] | PI
 | Trent Clemments | 7021459 | [NAME] | PI
 | [NAME] |  | Painter | A & B