Spreadsheet: 788357d1658416004-sumifs-or-countifs-on-multiple-rows-and-columns-holiday-planner-for-testing
Sheet: MONTHLY PAYROLL SHEETS

BRANCH/DEPT
DATES OF PERIOD | 9TH DECEMBER TO 19TH JANUARY |  |  |  | MONTH |  | JANUARY
 |  | Deductions (Day) |  | Overtime (Hrs) | Leave (Day) | Dates/Details of any deductions |  |  |  | Annual Leave dates (applicable if sick dates)
Employee Name | Start/Leaver Date | Sick | Other | OT | Annual Leave
 |  |  |  |  |  |  |  |  |  | 10th - 14th January
NOTES RELATING TO PAYROLL
BRANCH/DEPT
DATES OF PERIOD | 20TH JANUARY TO 16TH FEBRUARY |  |  |  | MONTH |  | FEBRUARY
 |  | Deductions (Day) |  | Overtime (Hrs) | Leave (Day) | Dates/Details of any deductions |  |  |  | Annual Leave dates (applicable if sick dates)
Employee Name | Start/Leaver Date | Sick | Other | OT | Annual Leave
 |  |  |  |  |  | Sick dates 7th - 18th Feb
 |  |  |  |  |  | Sick dates 25th & 26th Jan |  |  |  | 24th Jan, 2nd - 4th & 14th- 16th Feb
 |  |  |  |  |  | Sick dates 31st - 18th Feb |  |  |  | 4th, 7th & 8th Feb Comp leave
 |  |  |  |  |  | Sick dates 2nd - 15th Feb
NOTES RELATING TO PAYROLL
BRANCH/DEPT
DATES OF PERIOD | 17TH FEBRURY TO 23RD [NAME] |  |  |  | MONTH |  | [NAME]
 |  | Deductions (Day) |  | Overtime (Hrs) | Leave (Day) | Dates/Details of any deductions |  |  |  | Annual Leave dates (applicable if sick dates)
Employee Name | Start/Leaver Date | Sick | Other | OT | Annual Leave
 |  |  |  |  |  |  |  |  |  | 4th & 7th March
 | Left 4th March
NOTES RELATING TO PAYROLL
[NAME] Isolating 4 days, [NAME] Isolating 10 days, [NAME] Isolating 9 days. [NAME] left 4th March owed 4 days holidays.
BRANCH/DEPT
DATES OF PERIOD | 24TH MARCH TO 20TH APRIL |  |  |  | MONTH |  | APRIL
 |  | Deductions (Day) |  | Overtime (Hrs) | Leave (Day) | Dates/Details of any deductions |  |  |  | Annual Leave dates (applicable if sick dates)
Employee Name | Start/Leaver Date | Sick | Other | OT | Annual Leave
NOTES RELATING TO PAYROLL
BRANCH/DEPT
DATES OF PERIOD | 21ST APRIL TO 18TH MAY |  |  |  | MONTH |  | MAY
 |  | Deductions (Day) |  | Overtime (Hrs) | Leave (Day) | Dates/Details of any deductions |  |  |  | Annual Leave dates (applicable if sick dates)
Employee Name | Start/Leaver Date | Sick | Other | OT | Annual Leave
NOTES RELATING TO PAYROLL
BRANCH/DEPT
DATES OF PERIOD | 19TH MAY TO 22ND JUNE |  |  |  | MONTH |  | [NAME]
 |  | Deductions (Day) |  | Overtime (Hrs) | Leave (Day) | Dates/Details of any deductions |  |  |  | Annual Leave dates (applicable if sick dates)
Employee Name | Start/Leaver Date | Sick | Other | OT | Annual Leave
NOTES RELATING TO PAYROLL
BRANCH/DEPT
DATES OF PERIOD | 23RD JUNE TO 20TH JULY |  |  |  | MONTH |  | JULY
 |  | Deductions (Day) |  | Overtime (Hrs) | Leave (Day) | Dates/Details of any deductions |  |  |  | Annual Leave dates (applicable if sick dates)
Employee Name | Start/Leaver Date | Sick | Other | OT | Annual Leave
NOTES RELATING TO PAYROLL
BRANCH/DEPT
DATES OF PERIOD | 21ST JULY TO 17TH AUG |  |  |  | MONTH |  | AUGUST
 |  | Deductions (Day) |  | Overtime (Hrs) | Leave (Day) | Dates/Details of any deductions |  |  |  | Annual Leave dates (applicable if sick dates)
Employee Name | Start/Leaver Date | Sick | Other | OT | Annual Leave
NOTES RELATING TO PAYROLL
BRANCH/DEPT
DATES OF PERIOD | 18TH AUGUST TO 21ST SEPTEMBER |  |  |  | MONTH |  | SEPTEMBER
 |  | Deductions (Day) |  | Overtime (Hrs) | Leave (Day) | Dates/Details of any deductions |  |  |  | Annual Leave dates (applicable if sick dates)
Employee Name | Start/Leaver Date | Sick | Other | OT | Annual Leave
NOTES RELATING TO PAYROLL
BRANCH/DEPT
DATES OF PERIOD | 22ND SEPTEMBER TO 19TH OCTOBER |  |  |  | MONTH |  | OCTOBER
 |  | Deductions (Day) |  | Overtime (Hrs) | Leave (Day) | Dates/Details of any deductions |  |  |  | Annual Leave dates (applicable if sick dates)
Employee Name | Start/Leaver Date | Sick | Other | OT | Annual Leave
NOTES RELATING TO PAYROLL
BRANCH/DEPT
DATES OF PERIOD | 20TH OCTOBER TO 16TH NOVEMBER |  |  |  | MONTH |  | NOVEMBER
 |  | Deductions (Day) |  | Overtime (Hrs) | Leave (Day) | Dates/Details of any deductions |  |  |  | Annual Leave dates (applicable if sick dates)
Employee Name | Start/Leaver Date | Sick | Other | OT | Annual Leave
NOTES RELATING TO PAYROLL
BRANCH/DEPT
DATES OF PERIOD | 17TH NOVEMBER TO 7TH DECEMBER |  |  |  | MONTH |  | DECEMBER
 |  | Deductions (Day) |  | Overtime (Hrs) | Leave (Day) | Dates/Details of any deductions |  |  |  | Annual Leave dates (applicable if sick dates)
Employee Name | Start/Leaver Date | Sick | Other | OT | Annual Leave
NOTES RELATING TO PAYROLL