Spreadsheet: 847490d1698398695-help-with-excel-formula-excel-help
Sheet: Test Holiday

 |  |  |  | 2024-01-01 00:00:00 |  | 1
Holidays Available to book |  |  |  |  |  |  |  |  |  |  |  | 23.68 | 19.56 | 17.96 | 18.45 | 19.43 | 19.38 | 6.5 | 23.68 | 19.56 | 17.96 | 18.45 | 19.43 | 19.38 | 6.5 | 23.68 | 19.56 | 17.96 | 18.45 | 19.43 | 19.38 | 6.5 | 23.68 | 19.56 | 17.96 | 18.45 | 19.43 | 19.38 | 6.5 |  | 23.68 | 19.56 | 17.96 | 18.45 | 19.43 | 19.38 | 6.5 | 23.68 | 19.56 | 17.96 | 18.45 | 19.43 | 19.38 | 6.5 | 23.68 | 19.56 | 17.96 | 18.45 | 19.43 | 19.38 | 6.5 | 23.68 | 19.56 | 17.96 | 18.45 | 19.43 | 19.38 | 6.5 |  | 23.68 | 19.56 | 17.96 | 18.45 | 19.43 | 19.38 | 6.5 | 23.68 | 19.56 | 17.96 | 18.45 | 19.43 | 19.38 | 6.5 | 23.68 | 19.56 | 17.96 | 18.45 | 19.43 | 19.38 | 6.5 | 23.68 | 19.56 | 17.96 | 18.45 | 19.43 | 19.38 | 6.5 | 23.68 | 19.56 | 17.96 | 18.45 | 19.43 | 19.38 | 6.5 |  | 23.68 | 19.56 | 17.96 | 18.45 | 19.43 | 19.38 | 6.5 | 23.68 | 19.56 | 17.96 | 18.45 | 19.43 | 19.38 | 6.5 | 23.68 | 19.56 | 17.96 | 18.45 | 19.43 | 19.38 | 6.5 | 23.68 | 19.56 | 17.96 | 18.45 | 19.43 | 19.38 | 6.5 |  | 23.68 | 19.56 | 17.96 | 18.45 | 19.43 | 19.38 | 6.5 | 23.68 | 19.56 | 17.96 | 18.45 | 19.43 | 19.38 | 6.5 | 23.68 | 19.56 | 17.96 | 18.45 | 19.43 | 19.38 | 6.5 | 23.68 | 19.56 | 17.96 | 18.45 | 19.43 | 19.38 | 6.5 |  | 23.68 | 19.56 | 17.96 | 18.45 | 19.43 | 19.38 | 6.5 | 23.68 | 19.56 | 17.96 | 18.45 | 19.43 | 19.38 | 6.5 | 23.68 | 19.56 | 17.96 | 18.45 | 19.43 | 19.38 | 6.5 | 23.68 | 19.56 | 17.96 | 18.45 | 19.43 | 19.38 | 6.5 | 23.68 | 19.56 | 17.96 | 18.45 | 19.43 | 19.38 | 6.5 |  | 23.68 | 19.56 | 17.96 | 18.45 | 19.43 | 19.38 | 6.5 | 23.68 | 19.56 | 17.96 | 18.45 | 19.43 | 19.38 | 6.5 | 23.68 | 19.56 | 17.96 | 18.45 | 19.43 | 19.38 | 6.5 | 23.68 | 19.56 | 17.96 | 18.45 | 19.43 | 19.38 | 6.5 | 23.68 | 19.56 | 17.96 | 18.45 | 19.43 | 19.38 | 6.5 |  | 23.68 | 19.56 | 17.96 | 18.45 | 19.43 | 19.38 | 6.5 | 23.68 | 19.56 | 17.96 | 18.45 | 19.43 | 19.38 | 6.5 | 23.68 | 19.56 | 17.96 | 18.45 | 19.43 | 19.38 | 6.5 | 23.68 | 19.56 | 17.96 | 18.45 | 19.43 | 19.38 | 6.5 |  | 23.68 | 19.56 | 17.96 | 18.45 | 19.43 | 19.38 | 6.5 | 23.68 | 19.56 | 17.96 | 18.45 | 19.43 | 19.38 | 6.5 | 23.68 | 19.56 | 17.96 | 18.45 | 19.43 | 19.38 | 6.5 | 23.68 | 19.56 | 17.96 | 18.45 | 19.43 | 19.38 | 6.5 |  | 23.68 | 19.56 | 17.96 | 18.45 | 19.43 | 19.38 | 6.5 | 23.68 | 19.56 | 17.96 | 18.45 | 19.43 | 19.38 | 6.5 | 23.68 | 19.56 | 17.96 | 18.45 | 19.43 | 19.38 | 6.5 | 23.68 | 19.56 | 17.96 | 18.45 | 19.43 | 19.38 | 6.5 |  | 23.68 | 19.56 | 17.96 | 18.45 | 19.43 | 19.38 | 6.5 | 23.68 | 19.56 | 17.96 | 18.45 | 19.43 | 19.38 | 6.5 | 23.68 | 19.56 | 17.96 | 18.45 | 19.43 | 19.38 | 6.5 | 23.68 | 19.56 | 17.96 | 18.45 | 19.43 | 19.38 | 6.5 |  | 23.68 | 19.56 | 17.96 | 18.45 | 19.43 | 19.38 | 6.5 | 23.68 | 19.56 | 17.96 | 18.45 | 19.43 | 19.38 | 6.5 | 23.68 | 19.56 | 17.96 | 18.45 | 19.43 | 19.38 | 6.5 | 23.68 | 19.56 | 17.96 | 18.45 | 19.43 | 19.38 | 6.5 | 23.68 | 19.56 | 17.96 | 18.45 | 19.43 | 19.38 | 6.5
Daily Holidays Booked
Daily Holidays Available to book
Name | START DATE | LENGTH  OF SERVICE (YEARS) | SERVICE HOURS | Manager | HOLIDAY HOURS | BOUGHT | TOTAL ENT | USED | REMAINING | [NAME] WORK HRS | DAILY HOURS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jan |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Feb |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mar |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Apr |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | May |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | June |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jul |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Aug |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sept |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Oct |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nov |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dec
 |  |  |  |  |  |  |  |  |  |  |  | WEEK 1 |  |  |  |  |  |  | WEEK 2 |  |  |  |  |  |  | WEEK 3 |  |  |  |  |  |  | WEEK 4 |  |  |  |  |  |  | Total | WEEK 5 |  |  |  |  |  |  | WEEK 6 |  |  |  |  |  |  | WEEK 7 |  |  |  |  |  |  | WEEK 8 |  |  |  |  |  |  | Total | WEEK 9 |  |  |  |  |  |  | WEEK 10 |  |  |  |  |  |  | WEEK 11 |  |  |  |  |  |  | WEEK 12 |  |  |  |  |  |  | WEEK 13 |  |  |  |  |  |  | Total | WEEK 14 |  |  |  |  |  |  | WEEK 15 |  |  |  |  |  |  | WEEK 16 |  |  |  |  |  |  | WEEK 17 |  |  |  |  |  |  | Total | WEEK 18 |  |  |  |  |  |  | WEEK 19 |  |  |  |  |  |  | WEEK 20 |  |  |  |  |  |  | WEEK 21 |  |  |  |  |  |  | Total | WEEK 22 |  |  |  |  |  |  | WEEK 23 |  |  |  |  |  |  | WEEK 24 |  |  |  |  |  |  | WEEK 25 |  |  |  |  |  |  | WEEK 26 |  |  |  |  |  |  | Total | WEEK 27 |  |  |  |  |  |  | WEEK 28 |  |  |  |  |  |  | WEEK 29 |  |  |  |  |  |  | WEEK 30 |  |  |  |  |  |  | WEEK 31 |  |  |  |  |  |  | Total | WEEK 32 |  |  |  |  |  |  | WEEK 33 |  |  |  |  |  |  | WEEK 34 |  |  |  |  |  |  | WEEK 35 |  |  |  |  |  |  | Total | WEEK 36 |  |  |  |  |  |  | WEEK 37 |  |  |  |  |  |  | WEEK 38 |  |  |  |  |  |  | WEEK 39 |  |  |  |  |  |  | Total | WEEK 40 |  |  |  |  |  |  | WEEK 41 |  |  |  |  |  |  | WEEK 42 |  |  |  |  |  |  | WEEK 43 |  |  |  |  |  |  | Total | WEEK 44 |  |  |  |  |  |  | WEEK 45 |  |  |  |  |  |  | WEEK 46 |  |  |  |  |  |  | WEEK 47 |  |  |  |  |  |  | Total | WEEK 32 |  |  |  |  |  |  | WEEK 33 |  |  |  |  |  |  | WEEK 34 |  |  |  |  |  |  | WEEK 35 |  |  |  |  |  |  | WEEK 35 |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  |  |  |  | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S |  | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S |  | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S |  | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S |  | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S |  | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S |  | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S |  | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S |  | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S |  | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S |  | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S |  | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Work out hours
 | 2020-08-01 00:00:00 |  |  |  | 250 | 37.5 |  |  |  | 22.5 | 7.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | weekly hours / 5 *32