Spreadsheet: 36087d1233851563-how-to-deduct-holidays-and-take-multiple-projects-into-account-in-a-report-monthly-report-with-holidays
Sheet: holidays

 | November |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | December |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | January
 | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
Employee | 2008-11-01 00:00:00 | 2008-11-02 00:00:00 | 2008-11-03 00:00:00 | 2008-11-04 00:00:00 | 2008-11-05 00:00:00 | 2008-11-06 00:00:00 | 2008-11-07 00:00:00 | 2008-11-08 00:00:00 | 2008-11-09 00:00:00 | 2008-11-10 00:00:00 | 2008-11-11 00:00:00 | 2008-11-12 00:00:00 | 2008-11-13 00:00:00 | 2008-11-14 00:00:00 | 2008-11-15 00:00:00 | 2008-11-16 00:00:00 | 2008-11-17 00:00:00 | 2008-11-18 00:00:00 | 2008-11-19 00:00:00 | 2008-11-20 00:00:00 | 2008-11-21 00:00:00 | 2008-11-22 00:00:00 | 2008-11-23 00:00:00 | 2008-11-24 00:00:00 | 2008-11-25 00:00:00 | 2008-11-26 00:00:00 | 2008-11-27 00:00:00 | 2008-11-28 00:00:00 | 2008-11-29 00:00:00 | 2008-11-30 00:00:00 | 2008-12-01 00:00:00 | 2008-12-02 00:00:00 | 2008-12-03 00:00:00 | 2008-12-04 00:00:00 | 2008-12-05 00:00:00 | 2008-12-06 00:00:00 | 2008-12-07 00:00:00 | 2008-12-08 00:00:00 | 2008-12-09 00:00:00 | 2008-12-10 00:00:00 | 2008-12-11 00:00:00 | 2008-12-12 00:00:00 | 2008-12-13 00:00:00 | 2008-12-14 00:00:00 | 2008-12-15 00:00:00 | 2008-12-16 00:00:00 | 2008-12-17 00:00:00 | 2008-12-18 00:00:00 | 2008-12-19 00:00:00 | 2008-12-20 00:00:00 | 2008-12-21 00:00:00 | 2008-12-22 00:00:00 | 2008-12-23 00:00:00 | 2008-12-24 00:00:00 | 2008-12-25 00:00:00 | 2008-12-26 00:00:00 | 2008-12-27 00:00:00 | 2008-12-28 00:00:00 | 2008-12-29 00:00:00 | 2008-12-30 00:00:00 | 2008-12-31 00:00:00 | 2009-01-01 00:00:00 | 2009-01-02 00:00:00 | 2009-01-03 00:00:00 | 2009-01-04 00:00:00 | 2009-01-05 00:00:00 | 2009-01-06 00:00:00 | 2009-01-07 00:00:00 | 2009-01-08 00:00:00 | 2009-01-09 00:00:00 | 2009-01-10 00:00:00 | 2009-01-11 00:00:00 | 2009-01-12 00:00:00 | 2009-01-13 00:00:00 | 2009-01-14 00:00:00 | 2009-01-15 00:00:00 | 2009-01-16 00:00:00 | 2009-01-17 00:00:00 | 2009-01-18 00:00:00 | 2009-01-19 00:00:00 | 2009-01-20 00:00:00 | 2009-01-21 00:00:00 | 2009-01-22 00:00:00 | 2009-01-23 00:00:00 | 2009-01-24 00:00:00 | 2009-01-25 00:00:00 | 2009-01-26 00:00:00 | 2009-01-27 00:00:00 | 2009-01-28 00:00:00 | 2009-01-29 00:00:00 | 2009-01-30 00:00:00 | 2009-01-31 00:00:00
Mr White |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H |  |  | PH | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H | PH | PH | PH |  |  | H | H | PH | PH | PH |  |  |  |  |  |  |  |  |  | H | H | H | H | H
Mr Orange |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PH |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H | H | PH | PH | PH |  |  | H | H | PH | PH | PH
Mr Blonde |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PH |  |  |  |  |  |  |  |  |  |  | H |  |  |  |  |  |  |  |  |  |  | H | PH | PH | PH |  |  | H | H | PH | PH | PH
Mr Pink |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H | H |  |  |  |  |  |  |  |  |  | PH |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H | H | PH | PH | PH |  |  | H | H | PH | PH | PH
Mr Blue |  |  |  |  |  | H | H |  |  |  |  |  | H | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PH |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H |  |  | H | H | PH | PH | PH |  |  | H | H | PH | PH | PH
Mr [NAME] | PH |  | H | H | H | H | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H | H | PH | PH | PH |  |  | H | H | PH | PH | H |  |  | H | PH | H | H | H
PH = Public Holiday
H = Holiday