Spreadsheet: 860830d1708857900-a-networkday-formula-that-excludes-holidays-and-multiple-leave-date-entries-by-employee-new-working-file_edit-for-hans
Sheet: Leave Sheet

FORMULA | Start date: | End date: | Value:
11002902 | 2024-01-08 00:00:00 | 2024-01-12 00:00:00 | 2
11026794 | 2024-01-11 00:00:00 | 2024-01-11 00:00:00 | 2
11031173 | 2024-01-25 00:00:00 | 2024-01-25 00:00:00 | 2
213681 | 2024-01-08 00:00:00 | 2024-06-24 00:00:00 | 2
213681 | 2024-01-12 00:00:00 | 2024-06-28 00:00:00 | 2
175868 | 2024-02-19 00:00:00 | 2024-02-23 00:00:00 | 2
175868 | 2024-03-11 00:00:00 | 2024-03-15 00:00:00 | 2
175868 | 2024-03-25 00:00:00 | 2024-03-29 00:00:00 | 2
214686 | 2023-11-29 00:00:00 | 2024-02-24 00:00:00 | 2
11018149 | 2024-01-23 00:00:00 | 2024-01-26 00:00:00 | 2
11045195 | 2023-12-27 00:00:00 | 2024-01-12 00:00:00 | 2
11026563 | 2024-12-09 00:00:00 | 2024-12-31 00:00:00 | 2
11026563 | 2025-01-02 00:00:00 | 2025-01-24 00:00:00 | 2
224245 | 2024-01-02 00:00:00 | 2024-01-12 00:00:00 | 2
220095 | 2023-12-21 00:00:00 | 2024-01-26 00:00:00 | 2
11027881 | 2024-03-11 00:00:00 | 2024-03-22 00:00:00 | 2
11027881 | 2024-05-27 00:00:00 | 2024-06-07 00:00:00 | 2
222303 | 2023-12-27 00:00:00 | 2024-01-19 00:00:00 | 2
11039699 | 2023-10-16 00:00:00 | 2024-01-21 00:00:00 | 2
11039699 | 2024-01-22 00:00:00 | 2024-02-28 00:00:00 | 2
11043112 | 2024-01-16 00:00:00 | 2024-01-25 00:00:00 | 2
215467 | 2024-01-15 00:00:00 | 2024-01-25 00:00:00 | 2
11040634 | 2024-01-09 00:00:00 | 2024-01-10 00:00:00 | 2
11040634 | 2024-01-22 00:00:00 | 2024-01-25 00:00:00 | 2
138853 | 2024-02-01 00:00:00 | 2024-04-05 00:00:00 | 2
138337 | 2023-12-25 00:00:00 | 2024-01-17 00:00:00 | 2
11020720 | 2024-01-15 00:00:00 | 2024-01-19 00:00:00 | 2
11027472 | 2024-01-22 00:00:00 | 2024-01-25 00:00:00 | 2
11027472 | 2024-01-29 00:00:00 | 2024-01-30 00:00:00 | 2
11048391 | 2024-08-30 00:00:00 | 2024-09-03 00:00:00 | 2
125875 | 2023-12-27 00:00:00 | 2024-01-12 00:00:00 | 2
11031544 | 2023-12-25 00:00:00 | 2024-01-12 00:00:00 | 2
11002942 | 2023-12-21 00:00:00 | 2024-01-10 00:00:00 | 2
11007267 | 2024-01-23 00:00:00 | 2024-02-08 00:00:00 | 2
11027919 | 2023-12-18 00:00:00 | 2024-01-12 00:00:00 | 2
11010476 | 2024-02-12 00:00:00 | 2024-03-15 00:00:00 | 2
11035491 | 2023-12-18 00:00:00 | 2024-01-16 00:00:00 | 2
11026897 | 2023-12-21 00:00:00 | 2024-01-12 00:00:00 | 2
11026897 | 2024-10-07 00:00:00 | 2024-10-11 00:00:00 | 2
109912 | 2024-01-02 00:00:00 | 2024-01-15 00:00:00 | 2
109912 | 2024-03-04 00:00:00 | 2024-03-08 00:00:00 | 2
109912 | 2024-05-13 00:00:00 | 2024-05-17 00:00:00 | 2
109912 | 2024-06-17 00:00:00 | 2024-06-21 00:00:00 | 2
109912 | 2024-07-15 00:00:00 | 2024-07-19 00:00:00 | 2
204081 | 2023-12-21 00:00:00 | 2024-01-10 00:00:00 | 2
204081 | 2024-01-11 00:00:00 | 2024-01-15 00:00:00 | 2
214688 | 2023-12-22 00:00:00 | 2024-01-12 00:00:00 | 2
123515 | 2024-01-29 00:00:00 | 2024-02-02 00:00:00 | 2
208385 | 2023-12-25 00:00:00 | 2024-01-12 00:00:00 | 2
208385 | 2024-03-11 00:00:00 | 2024-03-18 00:00:00 | 2
213553 | 2024-02-05 00:00:00 | 2024-02-16 00:00:00 | 2
213553 | 2024-04-22 00:00:00 | 2024-06-28 00:00:00 | 2
222413 | 2024-05-15 00:00:00 | 2024-06-05 00:00:00 | 2
222413 | 2024-12-20 00:00:00 | 2025-01-06 00:00:00 | 2
222413 | 2025-04-01 00:00:00 | 2025-04-11 00:00:00 | 2
11045291 | 2023-12-25 00:00:00 | 2024-01-10 00:00:00 | 2
11045291 | 2024-01-19 00:00:00 | 2024-01-19 00:00:00 | 2
11045291 | 2024-01-29 00:00:00 | 2024-01-29 00:00:00 | 2
223749 | 2023-12-25 00:00:00 | 2024-01-20 00:00:00 | 2
117031 | 2024-01-08 00:00:00 | 2024-01-22 00:00:00 | 2
11031386 | 2023-12-21 00:00:00 | 2024-01-12 00:00:00 | 2
144339 | 2023-12-21 00:00:00 | 2024-01-19 00:00:00 | 2
144339 | 2024-01-29 00:00:00 | 2024-01-29 00:00:00 | 2
144339 | 2024-04-02 00:00:00 | 2024-10-01 00:00:00 | 2
11040135 | 2024-01-22 00:00:00 | 2024-01-25 00:00:00 | 2
207574 | 2023-12-25 00:00:00 | 2024-01-19 00:00:00 | 2
176951 | 2023-12-20 00:00:00 | 2024-01-12 00:00:00 | 2
168090 | 2024-01-16 00:00:00 | 2024-01-18 00:00:00 | 2
11035470 | 2024-01-09 00:00:00 | 2024-01-12 00:00:00 | 2
11035470 | 2024-01-22 00:00:00 | 2024-01-25 00:00:00 | 2
11035470 | 2024-01-29 00:00:00 | 2024-01-31 00:00:00 | 2
11038805 | 2023-12-22 00:00:00 | 2024-01-17 00:00:00 | 2
173232 | 2023-12-27 00:00:00 | 2024-01-25 00:00:00 | 2
214500 | 2024-01-22 00:00:00 | 2024-01-23 00:00:00 | 2
214500 | 2024-01-25 00:00:00 | 2024-01-30 00:00:00 | 2
178513 | 2023-12-18 00:00:00 | 2024-01-12 00:00:00 | 2
11026929 | 2023-12-21 00:00:00 | 2024-01-12 00:00:00 | 2
173304 | 2024-01-08 00:00:00 | 2024-01-12 00:00:00 | 2
11031395 | 2024-01-08 00:00:00 | 2024-02-07 00:00:00 | 2
11031395 | 2024-02-08 00:00:00 | 2024-02-09 00:00:00 | 2
224046 | 2024-05-24 00:00:00 | 2024-06-07 00:00:00 | 2
11045397 | 2024-01-29 00:00:00 | 2024-01-31 00:00:00 | 2
11041311 | 2023-12-20 00:00:00 | 2024-01-12 00:00:00 | 2
215109 | 2024-01-15 00:00:00 | 2024-01-19 00:00:00 | 2
11011191 | 2024-01-08 00:00:00 | 2024-01-19 00:00:00 | 2
220951 | 2024-01-08 00:00:00 | 2024-01-12 00:00:00 | 2
172557 | 2023-12-28 00:00:00 | 2024-01-30 00:00:00 | 2
11026739 | 2024-01-22 00:00:00 | 2024-01-25 00:00:00 | 2
11026739 | 2024-01-29 00:00:00 | 2024-02-16 00:00:00 | 2
215560 | 2024-03-11 00:00:00 | 2024-03-15 00:00:00 | 2
165533 | 2024-04-24 00:00:00 | 2024-05-10 00:00:00 | 2
165533 | 2024-12-23 00:00:00 | 2025-01-03 00:00:00 | 2
114483 | 2024-05-13 00:00:00 | 2024-05-17 00:00:00 | 2
209672 | 2024-01-29 00:00:00 | 2024-02-09 00:00:00 | 2
216108 | 2024-03-05 00:00:00 | 2024-03-19 00:00:00 | 2
216108 | 2024-06-14 00:00:00 | 2024-06-17 00:00:00 | 2
216108 | 2024-08-16 00:00:00 | 2024-08-19 00:00:00 | 2
196106 | 2023-12-18 00:00:00 | 2024-01-12 00:00:00 | 2
113952 | 2023-12-18 00:00:00 | 2024-01-11 00:00:00 | 2
113952 | 2024-01-12 00:00:00 | 2024-01-25 00:00:00 | 2
104872 | 2023-12-18 00:00:00 | 2024-01-12 00:00:00 | 2
11031813 | 2024-01-01 00:00:00 | 2024-01-12 00:00:00 | 2
194339 | 2023-12-22 00:00:00 | 2024-01-11 00:00:00 | 2
222780 | 2024-01-30 00:00:00 | 2024-01-31 00:00:00 | 2
121938 | 2024-02-12 00:00:00 | 2024-02-13 00:00:00 | 2
149879 | 2024-01-08 00:00:00 | 2024-02-02 00:00:00 | 2
169183 | 2024-02-05 00:00:00 | 2024-02-09 00:00:00 | 2
169183 | 2024-04-29 00:00:00 | 2024-04-30 00:00:00 | 2
11031407 | 2024-03-18 00:00:00 | 2024-04-01 00:00:00 | 2
11031407 | 2024-04-08 00:00:00 | 2024-04-08 00:00:00 | 2
11031407 | 2024-10-18 00:00:00 | 2024-10-21 00:00:00 | 2
11035232 | 2024-03-01 00:00:00 | 2024-03-01 00:00:00 | 2
11029730 | 2024-03-28 00:00:00 | 2024-04-02 00:00:00 | 2
11029730 | 2024-06-07 00:00:00 | 2024-06-10 00:00:00 | 2
11029730 | 2024-10-04 00:00:00 | 2024-10-07 00:00:00 | 2
182593 | 2024-01-15 00:00:00 | 2024-03-29 00:00:00 | 2
182593 | 2024-01-15 00:00:00 | 2024-03-25 00:00:00 | 2
11013686 | 2024-02-05 00:00:00 | 2024-02-09 00:00:00 | 2
11029699 | 2024-02-19 00:00:00 | 2024-02-23 00:00:00 | 2
215857 | 2024-04-08 00:00:00 | 2024-04-18 00:00:00 | 2
11048391 | 2024-04-26 00:00:00 | 2024-04-26 00:00:00 | 2
11045225 | 2024-02-01 00:00:00 | 2024-02-01 00:00:00 | 2
11046621 | 2024-01-29 00:00:00 | 2024-02-02 00:00:00 | 2
224361 | 2024-02-20 00:00:00 | 2024-02-21 00:00:00 | 2
207385 | 2024-02-05 00:00:00 | 2024-02-09 00:00:00 | 2
10008808 | 2024-02-15 00:00:00 | 2024-02-16 00:00:00 | 2
214688 | 2024-02-20 00:00:00 | 2024-02-20 00:00:00 | 2
214688 | 2024-02-27 00:00:00 | 2024-02-27 00:00:00 | 2
108292 | 2024-01-29 00:00:00 | 2024-02-01 00:00:00 | 2
11038750 | 2024-02-14 00:00:00 | 2024-02-23 00:00:00 | 2
222413 | 2024-05-09 00:00:00 | 2024-05-31 00:00:00 | 2
11045291 | 2024-02-02 00:00:00 | 2024-02-02 00:00:00 | 2
11045291 | 2024-05-02 00:00:00 | 2024-05-02 00:00:00 | 2
11035470 | 2024-02-01 00:00:00 | 2024-02-02 00:00:00 | 2
137651 | 2024-01-29 00:00:00 | 2024-02-09 00:00:00 | 2
137651 | 2024-02-12 00:00:00 | 2024-02-16 00:00:00 | 2
178513 | 2024-01-30 00:00:00 | 2024-02-01 00:00:00 | 2
224046 | 2024-07-29 00:00:00 | 2024-08-23 00:00:00 | 2
224046 | 2024-08-26 00:00:00 | 2024-09-06 00:00:00 | 2
114483 | 2024-02-14 00:00:00 | 2024-02-16 00:00:00 | 2
194339 | 2024-07-22 00:00:00 | 2024-08-02 00:00:00 | 2
184748 | 2023-02-12 00:00:00 | 2024-02-16 00:00:00 | 2