Spreadsheet: 829640d1684343027-highlight-duplicate-dates-on-calendar-with-multiple-conditions-with-conditional-formatting-vacationtrackersample
Sheet: Vacation Tracker 2023

Shift | Start | End | # of Days
M3 | 2023-01-04 00:00:00 | 2023-01-05 00:00:00 | 2
M5 | 2023-01-04 00:00:00 | 2023-01-05 00:00:00 | 2
M3 | 2023-01-04 00:00:00 | 2023-01-05 00:00:00 | 2
M5 | 2023-01-09 00:00:00 | 2023-01-09 00:00:00 | 1
M5 | 2023-01-09 00:00:00 | 2023-01-09 00:00:00 | 1
M5 | 2023-01-11 00:00:00 | 2023-01-12 00:00:00 | 2
T5 | 2023-01-12 00:00:00 | 2023-01-13 00:00:00 | 2
M5 | 2023-01-16 00:00:00 | 2023-01-16 00:00:00 | 1
T5 | 2023-01-17 00:00:00 | 2023-01-17 00:00:00 | 1
M5 | 2023-01-19 00:00:00 | 2023-01-19 00:00:00 | 1
T5 | 2023-01-20 00:00:00 | 2023-01-20 00:00:00 | 1
M5 | 2023-01-24 00:00:00 | 2023-01-24 00:00:00 | 1
M5 | 2023-01-27 00:00:00 | 2023-01-27 00:00:00 | 1
M5 | 2023-01-30 00:00:00 | 2023-01-30 00:00:00 | 1
T5 | 2023-02-01 00:00:00 | 2023-02-01 00:00:00 | 1
M3 | 2023-02-06 00:00:00 | 2023-02-06 00:00:00 | 1
T5 | 2023-02-10 00:00:00 | 2023-02-10 00:00:00 | 1
T5 | 2023-02-10 00:00:00 | 2023-02-10 00:00:00 | 1
M5 | 2023-02-10 00:00:00 | 2023-02-10 00:00:00 | 1
T5 | 2023-02-16 00:00:00 | 2023-02-16 00:00:00 | 1
M5 | 2023-02-17 00:00:00 | 2023-02-17 00:00:00 | 1
T3 | 2023-02-21 00:00:00 | 2023-02-24 00:00:00 | 4
M5 | 2023-02-23 00:00:00 | 2023-02-23 00:00:00 | 1
T5 | 2023-02-23 00:00:00 | 2023-02-23 00:00:00 | 1
T5 | 2023-03-08 00:00:00 | 2023-03-10 00:00:00 | 3
M3 | 2023-03-13 00:00:00 | 2023-03-16 00:00:00 | 4
T5 | 2023-03-14 00:00:00 | 2023-03-17 00:00:00 | 4
T5 | 2023-03-21 00:00:00 | 2023-03-24 00:00:00 | 4
M5 | 2023-03-21 00:00:00 | 2023-03-24 00:00:00 | 3
M3 | 2023-03-29 00:00:00 | 2023-03-29 00:00:00 | 1
T5 | 2023-03-30 00:00:00 | 2023-03-31 00:00:00 | 2
M3 | 2023-04-03 00:00:00 | 2023-04-03 00:00:00 | 1
M5 | 2023-04-03 00:00:00 | 2023-04-03 00:00:00 | 1
M3 | 2023-04-03 00:00:00 | 2023-04-03 00:00:00 | 1
M5 | 2023-04-04 00:00:00 | 2023-04-04 00:00:00 | 1
T3 | 2023-04-04 00:00:00 | 2023-04-04 00:00:00 | 1
M3 | 2023-04-10 00:00:00 | 2023-04-11 00:00:00 | 2
T3 | 2023-04-13 00:00:00 | 2023-04-14 00:00:00 | 2
T3 | 2023-04-14 00:00:00 | 2023-04-14 00:00:00 | 1
M5 | 2023-04-19 00:00:00 | 2023-04-19 00:00:00 | 1
T3 | 2023-04-19 00:00:00 | 2023-04-21 00:00:00 | 3
T5 | 2023-04-20 00:00:00 | 2023-04-21 00:00:00 | 2
T5 | 2023-04-21 00:00:00 | 2023-04-21 00:00:00 | 1
M5 | 2023-04-26 00:00:00 | 2023-04-26 00:00:00 | 1
M3 | 2023-04-26 00:00:00 | 2023-04-27 00:00:00 | 2
T5 | 2023-05-05 00:00:00 | 2023-05-05 00:00:00 | 1
T3 | 2023-05-05 00:00:00 | 2023-05-05 00:00:00 | 1
T3 | 2023-05-10 00:00:00 | 2023-05-10 00:00:00 | 1
T5 | 2023-05-12 00:00:00 | 2023-05-12 00:00:00 | 1
M3 | 2023-05-15 00:00:00 | 2023-05-15 00:00:00 | 1
M5 | 2023-05-17 00:00:00 | 2023-05-18 00:00:00 | 2
T3 | 2023-05-19 00:00:00 | 2023-05-19 00:00:00 | 1
M5 | 2023-05-22 00:00:00 | 2023-05-22 00:00:00 | 1
M3 | 2023-05-22 00:00:00 | 2023-05-22 00:00:00 | 1
M3 | 2023-05-23 00:00:00 | 2023-05-23 00:00:00 | 1
M3 | 2023-05-23 00:00:00 | 2023-05-26 00:00:00 | 4
T5 | 2023-05-25 00:00:00 | 2023-05-25 00:00:00 | 1
M3 | 2023-05-25 00:00:00 | 2023-05-25 00:00:00 | 1
T3 | 2023-05-26 00:00:00 | 2023-05-26 00:00:00 | 1
M3 | 2023-05-30 00:00:00 | 2023-06-01 00:00:00 | 3
M5 | 2023-05-30 00:00:00 | 2023-06-01 00:00:00 | 3
M3 | 2023-05-30 00:00:00 | 2023-06-01 00:00:00 | 3
T5 | 2023-06-08 00:00:00 | 2023-06-08 00:00:00 | 1
M5 | 2023-06-12 00:00:00 | 2023-06-12 00:00:00 | 1
T3 | 2023-06-14 00:00:00 | 2023-06-16 00:00:00 | 3
T3 | 2023-06-16 00:00:00 | 2023-06-16 00:00:00 | 1
T3 | 2023-06-23 00:00:00 | 2023-06-23 00:00:00 | 1
M5 | 2023-06-29 00:00:00 | 2023-06-29 00:00:00 | 0
M3 | 2023-06-29 00:00:00 | 2023-06-29 00:00:00 | 1
T5 | 2023-06-30 00:00:00 | 2023-06-30 00:00:00 | 1
T3 | 2023-06-30 00:00:00 | 2023-06-30 00:00:00 | 1
M5 | 2023-07-03 00:00:00 | 2023-07-03 00:00:00 | 1
T3 | 2023-07-03 00:00:00 | 2023-07-03 00:00:00 | 0
M3 | 2023-07-03 00:00:00 | 2023-07-03 00:00:00 | 1
M3 | 2023-07-03 00:00:00 | 2023-07-03 00:00:00 | 1
M5 | 2023-07-03 00:00:00 | 2023-07-06 00:00:00 | 3
M5 | 2023-07-03 00:00:00 | 2023-07-03 00:00:00 | 1
M5 | 2023-07-03 00:00:00 | 2023-07-06 00:00:00 | 3
M3 | 2023-07-03 00:00:00 | 2023-07-03 00:00:00 | 1
M3 | 2023-07-03 00:00:00 | 2023-07-03 00:00:00 | 1
M3 | 2023-07-03 00:00:00 | 2023-07-03 00:00:00 | 1
 | 2023-07-03 00:00:00 | 2023-07-03 00:00:00 | 1
M3 | 2023-07-05 00:00:00 | 2023-07-05 00:00:00 | 1
T5 | 2023-07-05 00:00:00 | 2023-07-05 00:00:00 | 1
M3 | 2023-07-05 00:00:00 | 2023-07-06 00:00:00 | 2
M3 | 2023-07-06 00:00:00 | 2023-07-06 00:00:00 | 1
T3 | 2023-07-07 00:00:00 | 2023-07-07 00:00:00 | 1
T3 | 2023-07-10 00:00:00 | 2023-07-14 00:00:00 | 4
T3 | 2023-07-13 00:00:00 | 2023-07-14 00:00:00 | 2
M5 | 2023-07-27 00:00:00 | 2023-07-27 00:00:00 | 1
T3 | 2023-07-28 00:00:00 | 2023-07-28 00:00:00 | 1
M5 | 2023-07-31 00:00:00 | 2023-07-31 00:00:00 | 1
T5 | 2023-08-01 00:00:00 | 2023-08-01 00:00:00 | 1
T3 | 2023-08-04 00:00:00 | 2023-08-04 00:00:00 | 1
T5 | 2023-08-08 00:00:00 | 2023-08-08 00:00:00 | 1
T3 | 2023-08-11 00:00:00 | 2023-08-11 00:00:00 | 1
T3 | 2023-08-11 00:00:00 | 2023-08-11 00:00:00 | 1
T3 | 2023-08-15 00:00:00 | 2023-08-18 00:00:00 | 4
T5 | 2023-08-15 00:00:00 | 2023-08-15 00:00:00 | 1
M3 | 2023-08-21 00:00:00 | 2023-08-24 00:00:00 | 4
T5 | 2023-08-22 00:00:00 | 2023-08-22 00:00:00 | 1
T5 | 2023-08-25 00:00:00 | 2023-08-25 00:00:00 | 1
M5 | 2023-08-28 00:00:00 | 2023-08-29 00:00:00 | 1
M3 | 2023-08-28 00:00:00 | 2023-08-31 00:00:00 | 4
M3 | 2023-08-30 00:00:00 | 2023-08-30 00:00:00 | 1
M3 | 2023-09-05 00:00:00 | 2023-09-07 00:00:00 | 3
M5 | 2023-09-05 00:00:00 | 2023-09-07 00:00:00 | 3
M3 | 2023-09-05 00:00:00 | 2023-09-07 00:00:00 | 3
T5 | 2023-09-05 00:00:00 | 2023-09-08 00:00:00 | 4
T5 | 2023-09-07 00:00:00 | 2023-09-08 00:00:00 | 2
T3 | 2023-09-19 00:00:00 | 2023-09-19 00:00:00 | 1
M5 | 2023-09-25 00:00:00 | 2023-09-25 00:00:00 | 1
M3 | 2023-10-18 00:00:00 | 2023-10-19 00:00:00 | 2
M3 | 2023-10-23 00:00:00 | 2023-10-26 00:00:00 | 4
 | 2023-10-27 00:00:00 | 2023-10-27 00:00:00 | 1
M3 | 2023-10-30 00:00:00 | 2023-10-30 00:00:00 | 1
 | 2023-10-31 00:00:00 | 2023-11-01 00:00:00 | 2
M3 | 2023-11-20 00:00:00 | 2023-11-22 00:00:00 | 3
M5 | 2023-11-20 00:00:00 | 2023-11-22 00:00:00 | 3
M3 | 2023-11-20 00:00:00 | 2023-11-22 00:00:00 | 3
T5 | 2023-11-21 00:00:00 | 2023-11-22 00:00:00 | 2
M3 | 2023-11-27 00:00:00 | 2023-11-30 00:00:00 | 4
M5 | 2023-11-27 00:00:00 | 2023-11-27 00:00:00 | 1
T5 | 2023-11-28 00:00:00 | 2023-12-01 00:00:00 | 4
M5 | 2023-11-30 00:00:00 | 2023-11-30 00:00:00 | 1
M3 | 2023-12-04 00:00:00 | 2023-12-05 00:00:00 | 2
M3 | 2023-12-06 00:00:00 | 2023-12-07 00:00:00 | 2
M3 | 2023-12-06 00:00:00 | 2023-12-07 00:00:00 | 2
M5 | 2023-12-06 00:00:00 | 2023-12-07 00:00:00 | 2
M5 | 2023-12-07 00:00:00 | 2023-12-07 00:00:00 | 1
M3 | 2023-12-11 00:00:00 | 2023-12-14 00:00:00 | 4
M3 | 2023-12-11 00:00:00 | 2023-12-11 00:00:00 | 1
M5 | 2023-12-11 00:00:00 | 2023-12-14 00:00:00 | 4
M3 | 2023-12-12 00:00:00 | 2023-12-14 00:00:00 | 3
M5 | 2023-12-14 00:00:00 | 2023-12-14 00:00:00 | 1
T5 | 2023-12-15 00:00:00 | 2023-12-15 00:00:00 | 1
M3 | 2023-12-18 00:00:00 | 2023-12-21 00:00:00 | 4
M5 | 2023-12-18 00:00:00 | 2023-12-21 00:00:00 | 4
M5 | 2023-12-18 00:00:00 | 2023-12-21 00:00:00 | 4
M3 | 2023-12-18 00:00:00 | 2023-12-21 00:00:00 | 4
M3 | 2023-12-21 00:00:00 | 2023-12-21 00:00:00 | 1
T5 | 2023-12-22 00:00:00 | 2023-12-22 00:00:00 | 1
T5 | 2023-12-22 00:00:00 | 2023-12-22 00:00:00 | 1