Spreadsheet: 733098d1621391092-formula-to-return-leave-data-between-two-dates-sick-leave-taken-entitlement-dates-sample-
Sheet: Data

Report title: Report of Sick Leave Taken - entitlement date
 |  |  |  |  |  |  | 2021-05-19 00:00:00
 |  |  |  |  |  |  | 08:50:53
 | Report name: SIC_ANN
 | Use for check requirenent for medical certificate
Selections:
 | Leave Type  equal  SIC  OK
Staff Member | Staff Member | Leave Type | Start Date | End Date | Days Taken | Hours Taken | Certificate | Bus Unit | Position Number
1003 | Brown P | SIC | 2021-05-02 00:00:00 | 2021-05-05 00:00:00 | 4 | 48 | Y | NAV | VCW01
1003 | Brown P | SIC | 2021-04-24 00:00:00 | 2021-04-27 00:00:00 | 4 | 48 | Y | NAV | VCW01
1003 | Brown P | SIC | 2021-04-16 00:00:00 | 2021-04-19 00:00:00 | 4 | 48 | Y | NAV | VCW01
1003 | Brown P | SIC | 2021-03-15 00:00:00 | 2021-03-18 00:00:00 | 4 | 48 | N | NAV | VCW01
1007 | Boss  M D | SIC | 2020-12-23 00:00:00 | 2020-12-23 00:00:00 | 0.75 | 9 | Y | SEC | PLO01
1007 | Boss  M D | SIC | 2020-12-15 00:00:00 | 2020-12-15 00:00:00 | 0.625 | 7.5 | N | SEC | PLO01
1007 | Boss  M D | SIC | 2020-11-13 00:00:00 | 2020-11-13 00:00:00 | 1 | 12 | N | SEC | PLO01
1007 | Boss  M D | SIC | 2020-10-11 00:00:00 | 2020-10-14 00:00:00 | 4 | 48 | Y | SEC | PLO01
1007 | Boss  M D | SIC | 2020-10-03 00:00:00 | 2020-10-06 00:00:00 | 4 | 48 | Y | SEC | PLO01
1007 | Boss  M D | SIC | 2020-09-25 00:00:00 | 2020-09-28 00:00:00 | 4 | 48 | Y | SEC | PLO01
1007 | Boss  M D | SIC | 2020-09-17 00:00:00 | 2020-09-20 00:00:00 | 4 | 48 | Y | SEC | PLO01
1007 | Boss  M D | SIC | 2020-09-09 00:00:00 | 2020-09-12 00:00:00 | 4 | 48 | Y | SEC | PLO01
1007 | Boss  M D | SIC | 2020-09-01 00:00:00 | 2020-09-04 00:00:00 | 4 | 48 | N | SEC | PLO01
1007 | Boss  M D | SIC | 2020-08-24 00:00:00 | 2020-08-28 00:00:00 | 4 | 48 | Y | SEC | PLO01
1007 | Boss  M D | SIC | 2020-08-16 00:00:00 | 2020-08-19 00:00:00 | 4 | 48 | N | SEC | PLO01
1007 | Boss  M D | SIC | 2020-05-13 00:00:00 | 2020-05-13 00:00:00 | 1 | 12 | Y | SEC | PLO01
1007 | Boss  M D | SIC | 2020-04-02 00:00:00 | 2020-04-03 00:00:00 | 2 | 24 | Y | SEC | PLO01
1007 | Boss  M D | SIC | 2020-02-28 00:00:00 | 2020-02-28 00:00:00 | 1 | 12 | Y | SEC | PLO01
1007 | Boss  M D | SIC | 2020-02-16 00:00:00 | 2020-02-17 00:00:00 | 2 | 24 | Y | SEC | PLO01
1007 | Boss  M D | SIC | 2020-01-23 00:00:00 | 2020-01-23 00:00:00 | 1 | 12 | Y | SEC | PLO01
1115 | [NAME] | SIC | 2021-03-11 00:00:00 | 2021-03-11 00:00:00 | 1 | 7.5 | N | FAC | WHF05
1115 | Boxy D L | SIC | 2020-08-07 00:00:00 | 2020-08-07 00:00:00 | 1 | 7.5 | N | FAC | WHF05
1115 | Boxy D L | SIC | 2020-06-24 00:00:00 | 2020-06-24 00:00:00 | 1 | 7.5 | N | FAC | WHF05
1115 | Boxy D L | SIC | 2020-05-25 00:00:00 | 2020-05-25 00:00:00 | 0.66666667 | 5.00000003 | N | FAC | WHF05
1115 | Boxy D L | SIC | 2020-03-20 00:00:00 | 2020-03-20 00:00:00 | 1 | 7.5 | N | FAC | WHF05
1115 | Boxy D L | SIC | 2020-02-27 00:00:00 | 2020-02-27 00:00:00 | 1 | 7.5 | N | FAC | WHF05
1115 | Boxy D L | SIC | 2020-01-16 00:00:00 | 2020-01-16 00:00:00 | 1 | 7.5 | N | FAC | WHF05
1114 | Boon G N | SIC | 2021-05-04 00:00:00 | 2021-05-04 00:00:00 | 1 | 7.5 | N | NAV | [NAME]
1114 | Boon G N | SIC | 2021-02-09 00:00:00 | 2021-02-09 00:00:00 | 1 | 7.5 | N | NAV | [NAME]
1114 | Boon G N | SIC | 2020-11-27 00:00:00 | 2020-11-27 00:00:00 | 1 | 7.5 | N | NAV | [NAME]
1121 | [NAME] | SIC | 2021-03-22 00:00:00 | 2021-03-22 00:00:00 | 0.46666667 | 3.50000003 | N | CORP | FNCLK
1121 | [NAME] | SIC | 2021-02-12 00:00:00 | 2021-02-12 00:00:00 | 1 | 7.5 | N | CORP | FNCLK
1121 | [NAME] | SIC | 2020-12-08 00:00:00 | 2020-12-08 00:00:00 | 1 | 7.5 | N | CORP | FNCLK
1121 | [NAME] | SIC | 2020-06-25 00:00:00 | 2020-06-25 00:00:00 | 0.26666667 | 2.00000003 | N | CORP | FNCLK
1121 | [NAME] | SIC | 2020-06-04 00:00:00 | 2020-06-04 00:00:00 | 1 | 7.5 | Y | CORP | FNCLK
1121 | [NAME] | SIC | 2020-04-14 00:00:00 | 2020-04-14 00:00:00 | 1 | 7.5 | N | CORP | FNCLK
1121 | [NAME] | SIC | 2020-03-13 00:00:00 | 2020-03-13 00:00:00 | 1 | 7.5 | N | CORP | FNCLK
1121 | [NAME] | SIC | 2020-01-23 00:00:00 | 2020-01-23 00:00:00 | 1 | 7.5 | N | CORP | FNCLK
1134 | Bell A M | SIC | 2021-05-19 00:00:00 | 2021-05-19 00:00:00 | 0.5 | 6 | N | NAV | HCO09
1134 | Bell A M | SIC | 2021-04-01 00:00:00 | 2021-04-01 00:00:00 | 1 | 12 | Y | NAV | HCO09
1134 | Bell A M | SIC | 2021-02-22 00:00:00 | 2021-02-23 00:00:00 | 2 | 24 | N | NAV | HCO09
1134 | Bell A M | SIC | 2020-10-01 00:00:00 | 2020-10-01 00:00:00 | 1 | 12 | N | NAV | HCO09
1134 | Bell A M | SIC | 2020-07-12 00:00:00 | 2020-07-12 00:00:00 | 1 | 12 | Y | NAV | HCO09
1134 | Bell A M | SIC | 2020-06-25 00:00:00 | 2020-06-26 00:00:00 | 2 | 24 | Y | NAV | HCO09
1134 | Bell A M | SIC | 2020-03-05 00:00:00 | 2020-03-08 00:00:00 | 4 | 48 | N | NAV | HCO09
1134 | Bell A M | SIC | 2020-02-26 00:00:00 | 2020-02-29 00:00:00 | 4 | 48 | Y | NAV | HCO09
1134 | Bell A M | SIC | 2020-01-02 00:00:00 | 2020-01-02 00:00:00 | 0.70833333 | 8.49999996 | N | NAV | HCO09
1134 | Bell A M | SIC | 2020-01-01 00:00:00 | 2020-01-01 00:00:00 | 1 | 12 | Y | NAV | HCO09