Spreadsheet: 876402d1723087887-sumproduct-and-networkdays-together-sample
Sheet: DataWorksheet

Leave | Co | Department | Staff Code | Sal. | Surname | First Name | Start Date | Status |  |  |  |  | 1 |  |  |  |  | Cycle
 | KID | Production | CHI001-0 | Ms |  |  | 2020-11-09 00:00:00 | Active |  |  |  |  |  |  |  |  |  | Start
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | End
 | Date From | 2023-11-06 00:00:00 | Date To | 2023-11-14 00:00:00 | Leave Type | SSD |  | Comments | Sick Child
 |  |  |  |  |  |  |  | Days
 | Leave Entitlement |  |  |  |  | Unpaid Days
 | Accrued Leave
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  | Falling in Current Cycle
RecordNum | Company | Department | Employee Code | Column1 | Column2 | Leave Type | Comment | Date From | Date To | Paid | Date Submitted | Days | [NAME]
1 | TU | Finance | ROW001-1 | Rowe | [NAME] | A | Holiday | 2024-07-01 00:00:00 | 2024-07-07 00:00:00 | Active | 2024-05-21 00:00:00
2 | TU | Finance | FOR001-1 | [NAME] | Veronica | A | Holiday | 2024-06-21 00:00:00 | 2024-06-23 00:00:00 | Active | 2024-05-21 00:00:00
3 | TU | Finance | PAR001-1 | [NAME] | Edwina | A | Holiday | 2024-06-21 00:00:00 | 2024-06-23 00:00:00 | Active | 2024-05-21 00:00:00
 | TU | Packing | BLO001-1 | Block | [NAME] | SSD | Muscle Spasm | 2024-07-18 00:00:00 | 2024-07-19 00:00:00 | Paid | 2024-07-19 13:02:25
 | TU | Production | LAM001-1 | [NAME] | [NAME] | SSD | Flu/Lower Back Pain | 2024-07-22 00:00:00 | 2024-07-24 00:00:00 | Paid | 2024-07-25 09:27:52
 | TU | Packing | PET005-1 | [NAME] | Eamonn | FR | Son has broken his hand | 2024-07-25 00:00:00 | 2024-07-25 00:00:00 | Paid | 2024-07-25 10:09:45
 | TU | [NAME] | NAI001-1 | Naidoo | Sivanesveri | A |  | 2024-07-26 00:00:00 | 2024-07-26 00:00:00 | Paid | 2024-07-25 13:12:37
 | TU | Packing | PEA002-1 | Pearce | Zelda | A | Emergency Leave - Daughter in hospital | 2024-08-01 00:00:00 | 2024-08-02 00:00:00 | Paid | 2024-07-26 14:08:14 | 2
 | TU | Production | CEL001-1 | Celie | Heber | A | Emergency Leave | 2024-07-30 00:00:00 | 2024-07-30 00:00:00 | Paid | 2024-07-26 15:00:18 | 1
 | BFA | Production | MAG001-1 | Magubane | Nado | SSD | Medical Condition - Doctors note from the 25th Jul | 2024-07-24 00:00:00 | 2024-07-24 00:00:00 | Unpaid | 2024-07-29 10:48:56 | 1
 | BFA | Production | MAG001-1 | Magubane | Nado | SSD | Medical Condition - Doctors note from the 25th Jul | 2024-07-25 00:00:00 | 2024-07-26 00:00:00 | Paid | 2024-07-29 10:49:34 | 2
 | TU | Marketing | PAN001-1 | Panya | Andisiwe | A | na | 2024-08-12 00:00:00 | 2024-08-12 00:00:00 | Paid | 2024-07-29 11:01:38 | 1
 | TSA | [NAME] | NDA001-1 | Ndaba | Siphiwe | A | na | 2024-07-29 00:00:00 | 2024-07-29 00:00:00 | Paid | 2024-07-29 11:02:48 | 1
 | TSA | [NAME] | ZWA001-1 | [NAME] | Victor | A | na | 2024-07-26 00:00:00 | 2024-07-29 00:00:00 | Paid | 2024-07-29 11:03:16 | 2
 | TU | Packing | DAN002-3 | Daniels | Shermonay | A | na | 2024-08-16 00:00:00 | 2024-08-16 00:00:00 | Paid | 2024-07-30 13:11:52 | 1
 | TU | Packing | SHU001-1 | Shumi | Phumza | A | 02/08 = 1/2 Day | 2024-08-02 00:00:00 | 2024-08-05 00:00:00 | Paid | 2024-07-30 13:13:27 | 1.5
 | TU | Packing | RYN003-1 | [NAME] | Miche | A | na | 2024-08-05 00:00:00 | 2024-08-05 00:00:00 | Paid | 2024-07-30 13:14:21 | 1
 | TU | Packing | GWA001-1 | [NAME] | Zelda | A | na | 2024-08-12 00:00:00 | 2024-08-12 00:00:00 | Paid | 2024-07-30 13:14:53 | 1
 | TU | Packing | GWA001-1 | [NAME] | Zelda | A | na | 2024-09-23 00:00:00 | 2024-09-23 00:00:00 | Paid | 2024-07-30 13:15:19 | 1
 | TU | Production | HAY003-1 | Haywood | Raymonde | SSD | Stomach | 2024-07-30 00:00:00 | 2024-07-30 00:00:00 | Paid | 2024-07-31 08:17:53 | 1
 | TU | Production | THE002-1 | Theunissen | Lucian | FR | Sick Child | 2024-07-31 00:00:00 | 2024-07-31 00:00:00 | Paid | 2024-08-01 08:27:51 | 1
 | KID | Production | CHI001-0 |  |  | SSD | Sick Child | 2024-08-01 00:00:00 | 2024-08-01 00:00:00 | Paid | 2024-08-02 08:26:35 | 1
 | KID | Production | CHI001-0 |  |  | SSD | Sick Child | 2023-11-06 00:00:00 | 2023-11-14 00:00:00 | Paid | 2024-08-06 08:21:26 | 7