Spreadsheet: 732384d1620921177-formula-to-match-the-next-closest-date-closest-dates
Sheet: Sheet1

Employee | Instances | Start Date | End Date | unique | Test1 | Test2
277406 |  | 2020-12-28 00:00:00 | 2021-04-04 00:00:00 | [PHONE]
279270 |  | 2021-02-15 00:00:00 | 2021-03-29 00:00:00 | [PHONE]
279791 |  | 2021-03-23 00:00:00 | 2021-04-05 00:00:00 | [PHONE]
279923 |  | 2021-02-19 00:00:00 | 2021-03-08 00:00:00 | [PHONE]
388773 |  | 2021-01-14 00:00:00 | 2021-03-01 00:00:00 | [PHONE]
390912 |  | 2021-01-13 00:00:00 | 2021-02-21 00:00:00 | [PHONE]
415629 |  | 2021-03-10 00:00:00 | 2021-03-10 00:00:00 | [PHONE]
464160 |  | 2020-12-15 00:00:00 | 2021-03-21 00:00:00 | [PHONE]
526319 |  | 2020-12-29 00:00:00 | 2021-02-13 00:00:00 | [PHONE]
529219 |  | 2021-02-03 00:00:00 | 2021-02-24 00:00:00 | [PHONE]
544873 |  | 2021-03-12 00:00:00 | 2021-04-25 00:00:00 | [PHONE]
560000 |  | 2021-03-23 00:00:00 | 2021-05-16 00:00:00 | [PHONE]
574683 |  | 2020-08-17 00:00:00 | 2021-02-16 00:00:00 | [PHONE]
595501 |  | 2021-01-09 00:00:00 | 2021-05-11 00:00:00 | [PHONE]
601067 |  | 2020-08-13 00:00:00 | 2021-02-17 00:00:00 | [PHONE]
601415 |  | 2021-01-05 00:00:00 | 2021-01-24 00:00:00 | [PHONE]
604293 |  | 2020-12-15 00:00:00 | 2021-01-17 00:00:00 | [PHONE]
625009 |  | 2020-12-15 00:00:00 | 2021-03-09 00:00:00 | [PHONE]
657278 |  | 2021-02-23 00:00:00 | 2021-04-20 00:00:00 | [PHONE]
657713 |  | 2020-12-23 00:00:00 | 2021-02-28 00:00:00 | [PHONE]
660957 |  | 2020-11-23 00:00:00 | 2021-01-18 00:00:00 | [PHONE]
663929 |  | 2020-12-04 00:00:00 | 2021-01-21 00:00:00 | [PHONE]
665596 |  | 2021-03-09 00:00:00 | 2021-03-27 00:00:00 | [PHONE]
667736 |  | 2020-11-04 00:00:00 | 2021-01-26 00:00:00 | [PHONE]
668106 |  | 2020-12-22 00:00:00 | 2021-03-28 00:00:00 | [PHONE]
668314 |  | 2020-12-30 00:00:00 | 2021-03-23 00:00:00 | [PHONE]
671692 |  | 2021-04-01 00:00:00 | 2021-05-02 00:00:00 | [PHONE]
671707 |  | 2020-11-03 00:00:00 | 2021-01-05 00:00:00 | [PHONE]
671955 |  | 2020-11-06 00:00:00 | 2021-01-17 00:00:00 | [PHONE]
671955 |  | 2021-03-31 00:00:00 | 2021-04-20 00:00:00 | [PHONE]
672230 |  | 2021-01-06 00:00:00 | 2021-01-19 00:00:00 | [PHONE]
672231 |  | 2021-04-09 00:00:00 | 2021-04-29 00:00:00 | [PHONE]
672372 |  | 2021-01-19 00:00:00 | 2021-04-15 00:00:00 | [PHONE]
672376 |  | 2021-01-19 00:00:00 | 2021-05-09 00:00:00 | [PHONE]
673794 |  | 2020-09-30 00:00:00 | 2021-01-15 00:00:00 | [PHONE]
673804 |  | 2020-12-10 00:00:00 | 2021-03-10 00:00:00 | [PHONE]
673840 |  | 2020-11-18 00:00:00 | 2021-01-01 00:00:00 | [PHONE]
673857 |  | 2020-12-23 00:00:00 | 2021-02-07 00:00:00 | [PHONE]
674026 |  | 2021-03-08 00:00:00 | 2021-03-23 00:00:00 | [PHONE]
674116 |  | 2021-01-22 00:00:00 | 2021-02-04 00:00:00 | [PHONE]
674121 |  | 2020-04-16 00:00:00 | 2021-04-15 00:00:00 | [PHONE]
674500 |  | 2020-12-25 00:00:00 | 2021-03-04 00:00:00 | [PHONE]
674512 |  | 2020-02-22 00:00:00 | 2021-04-17 00:00:00 | [PHONE]
674519 |  | 2021-02-18 00:00:00 | 2021-03-22 00:00:00 | [PHONE]
674535 |  | 2020-12-12 00:00:00 | 2021-03-04 00:00:00 | [PHONE]
674557 |  | 2020-08-25 00:00:00 | 2021-01-04 00:00:00 | [PHONE]
674564 |  | 2020-11-18 00:00:00 | 2021-03-04 00:00:00 | [PHONE]
674957 |  | 2021-04-26 00:00:00 | 2021-05-09 00:00:00 | [PHONE]
674980 |  | 2021-04-10 00:00:00 | 2021-04-27 00:00:00 | [PHONE]
675001 |  | 2021-02-04 00:00:00 | 2021-02-25 00:00:00 | [PHONE]
675004 |  | 2021-03-02 00:00:00 | 2021-03-21 00:00:00 | [PHONE]
675004 |  | 2021-03-25 00:00:00 | 2021-04-06 00:00:00 | [PHONE]
675008 |  | 2021-02-17 00:00:00 | 2021-02-28 00:00:00 | [PHONE]
675024 |  | 2020-09-25 00:00:00 | 2021-01-07 00:00:00 | [PHONE]
675192 |  | 2020-03-18 00:00:00 | 2021-04-10 00:00:00 | [PHONE]
675245 |  | 2021-03-30 00:00:00 | 2021-05-02 00:00:00 | [PHONE]
675287 |  | 2021-03-01 00:00:00 | 2021-03-14 00:00:00 | [PHONE]
675475 |  | 2020-12-10 00:00:00 | 2021-01-28 00:00:00 | [PHONE]
675660 |  | 2020-10-16 00:00:00 | 2021-02-18 00:00:00 | [PHONE]
676265 |  | 2021-03-07 00:00:00 | 2021-04-01 00:00:00 | [PHONE]
676278 |  | 2020-12-23 00:00:00 | 2021-02-07 00:00:00 | [PHONE]
676571 |  | 2021-02-26 00:00:00 | 2021-04-29 00:00:00 | [PHONE]
676638 |  | 2020-08-07 00:00:00 | 2021-02-04 00:00:00 | [PHONE]
676648 |  | 2020-12-21 00:00:00 | 2021-01-05 00:00:00 | [PHONE]
676648 |  | 2021-03-01 00:00:00 | 2021-03-09 00:00:00 | [PHONE]
676655 |  | 2021-03-04 00:00:00 | 2021-05-02 00:00:00 | [PHONE]
676697 |  | 2021-01-26 00:00:00 | 2021-03-08 00:00:00 | [PHONE]
676732 |  | 2020-07-30 00:00:00 | 2021-01-03 00:00:00 | [PHONE]
676752 |  | 2021-02-05 00:00:00 | 2021-03-01 00:00:00 | [PHONE]
676805 |  | 2020-11-25 00:00:00 | 2021-02-04 00:00:00 | [PHONE]
677390 |  | 2020-11-30 00:00:00 | 2021-01-14 00:00:00 | [PHONE]
677409 |  | 2021-03-11 00:00:00 | 2021-04-07 00:00:00 | [PHONE]
677411 |  | 2020-12-01 00:00:00 | 2021-02-22 00:00:00 | [PHONE]
677724 |  | 2021-03-20 00:00:00 | 2021-04-16 00:00:00 | [PHONE]
677837 |  | 2020-08-07 00:00:00 | 2021-01-10 00:00:00 | [PHONE]
677894 |  | 2021-04-09 00:00:00 | 2021-04-29 00:00:00 | [PHONE]
677929 |  | 2020-09-27 00:00:00 | 2021-03-27 00:00:00 | [PHONE]
677932 |  | 2021-05-03 00:00:00 | 2021-05-05 00:00:00 | [PHONE]
677933 |  | 2020-11-23 00:00:00 | 2021-01-24 00:00:00 | [PHONE]
677936 |  | 2020-11-12 00:00:00 | 2021-05-06 00:00:00 | [PHONE]
678148 |  | 2020-08-17 00:00:00 | 2021-01-30 00:00:00 | [PHONE]
678319 |  | 2021-03-08 00:00:00 | 2021-04-04 00:00:00 | [PHONE]
678325 |  | 2020-09-25 00:00:00 | 2021-03-25 00:00:00 | [PHONE]
678542 |  | 2020-09-30 00:00:00 | 2021-01-07 00:00:00 | [PHONE]
678825 |  | 2021-02-05 00:00:00 | 2021-03-02 00:00:00 | [PHONE]
679091 |  | 2021-01-09 00:00:00 | 2021-03-10 00:00:00 | [PHONE]
679145 |  | 2020-05-21 00:00:00 | 2021-04-01 00:00:00 | [PHONE]
679261 |  | 2021-02-24 00:00:00 | 2021-04-13 00:00:00 | [PHONE]
679289 |  | 2020-11-22 00:00:00 | 2021-02-25 00:00:00 | [PHONE]
679569 |  | 2020-06-24 00:00:00 | 2021-01-17 00:00:00 | [PHONE]
679609 |  | 2021-03-05 00:00:00 | 2021-03-06 00:00:00 | [PHONE]
679609 |  | 2021-05-01 00:00:00 | 2021-05-06 00:00:00 | [PHONE]
679745 |  | 2021-01-14 00:00:00 | 2021-03-24 00:00:00 | [PHONE]
680137 |  | 2021-01-04 00:00:00 | 2021-04-03 00:00:00 | [PHONE]
680759 |  | 2020-10-30 00:00:00 | 2021-04-11 00:00:00 | [PHONE]
681729 |  | 2021-04-02 00:00:00 | 2021-04-29 00:00:00 | [PHONE]
683833 |  | 2021-01-27 00:00:00 | 2021-02-07 00:00:00 | [PHONE]
687551 |  | 2020-12-23 00:00:00 | 2021-02-07 00:00:00 | [PHONE]
688479 |  | 2021-02-03 00:00:00 | 2021-03-10 00:00:00 | [PHONE]
688503 |  | 2021-02-24 00:00:00 | 2021-04-13 00:00:00 | [PHONE]
688507 |  | 2021-02-23 00:00:00 | 2021-04-10 00:00:00 | [PHONE]
689488 |  | 2021-03-29 00:00:00 | 2021-04-13 00:00:00 | [PHONE]
689817 |  | 2021-02-02 00:00:00 | 2021-02-14 00:00:00 | [PHONE]
689817 |  | 2021-02-18 00:00:00 | 2021-02-24 00:00:00 | [PHONE]
689817 |  | 2021-03-04 00:00:00 | 2021-03-14 00:00:00 | [PHONE]
690240 |  | 2020-10-14 00:00:00 | 2021-02-14 00:00:00 | [PHONE]
690894 |  | 2020-12-01 00:00:00 | 2021-01-05 00:00:00 | [PHONE]
691081 |  | 2021-01-25 00:00:00 | 2021-03-07 00:00:00 | [PHONE]
691250 |  | 2021-02-24 00:00:00 | 2021-03-23 00:00:00 | [PHONE]
691361 |  | 2021-02-24 00:00:00 | 2021-04-13 00:00:00 | [PHONE]
691369 |  | 2021-03-13 00:00:00 | 2021-05-04 00:00:00 | [PHONE]
691748 |  | 2021-02-23 00:00:00 | 2021-04-10 00:00:00 | [PHONE]
692301 |  | 2021-01-05 00:00:00 | 2021-01-10 00:00:00 | [PHONE]
692301 |  | 2021-01-28 00:00:00 | 2021-03-07 00:00:00 | [PHONE]
693703 |  | 2020-08-09 00:00:00 | 2021-04-20 00:00:00 | [PHONE]
693983 |  | 2020-06-24 00:00:00 | 2021-02-10 00:00:00 | [PHONE]
694094 |  | 2021-02-23 00:00:00 | 2021-04-10 00:00:00 | [PHONE]
694185 |  | 2020-08-24 00:00:00 | 2021-01-20 00:00:00 | [PHONE]
694185 |  | 2021-02-25 00:00:00 | 2021-04-14 00:00:00 | [PHONE]
694277 |  | 2020-09-18 00:00:00 | 2021-01-17 00:00:00 | [PHONE]
695498 |  | 2021-02-24 00:00:00 | 2021-04-13 00:00:00 | [PHONE]
695503 |  | 2020-09-09 00:00:00 | 2021-02-20 00:00:00 | [PHONE]
695503 |  | 2021-03-23 00:00:00 | 2021-04-24 00:00:00 | [PHONE]
696611 |  | 2021-02-23 00:00:00 | 2021-03-27 00:00:00 | [PHONE]
698259 |  | 2021-01-15 00:00:00 | 2021-04-14 00:00:00 | [PHONE]
700024 |  | 2021-02-24 00:00:00 | 2021-04-10 00:00:00 | [PHONE]
700025 |  | 2021-02-24 00:00:00 | 2021-03-24 00:00:00 | [PHONE]
700047 |  | 2021-02-23 00:00:00 | 2021-03-27 00:00:00 | [PHONE]
700048 |  | 2021-02-24 00:00:00 | 2021-03-23 00:00:00 | [PHONE]
700048 |  | 2021-03-25 00:00:00 | 2021-04-09 00:00:00 | [PHONE]
700055 |  | 2021-02-24 00:00:00 | 2021-04-10 00:00:00 | [PHONE]
700629 |  | 2020-08-05 00:00:00 | 2021-01-08 00:00:00 | [PHONE]
700643 |  | 2020-07-27 00:00:00 | 2021-04-03 00:00:00 | [PHONE]
700658 |  | 2021-02-23 00:00:00 | 2021-04-10 00:00:00 | [PHONE]
702463 |  | 2021-02-24 00:00:00 | 2021-04-10 00:00:00 | [PHONE]
702478 |  | 2021-02-24 00:00:00 | 2021-03-27 00:00:00 | [PHONE]
704447 |  | 2020-12-22 00:00:00 | 2021-01-14 00:00:00 | [PHONE]
704447 |  | 2021-02-21 00:00:00 | 2021-03-18 00:00:00 | [PHONE]
705029 |  | 2021-04-02 00:00:00 | 2021-04-23 00:00:00 | [PHONE]
705220 |  | 2021-02-23 00:00:00 | 2021-03-27 00:00:00 | [PHONE]
705221 |  | 2021-02-23 00:00:00 | 2021-04-10 00:00:00 | [PHONE]
705432 |  | 2021-02-26 00:00:00 | 2021-04-22 00:00:00 | [PHONE]
708327 |  | 2021-02-22 00:00:00 | 2021-03-24 00:00:00 | [PHONE]
708335 |  | 2021-02-08 00:00:00 | 2021-04-03 00:00:00 | [PHONE]
708956 |  | 2021-03-31 00:00:00 | 2021-05-01 00:00:00 | [PHONE]
709606 |  | 2021-03-09 00:00:00 | 2021-04-11 00:00:00 | [PHONE]
711289 |  | 2021-01-15 00:00:00 | 2021-04-16 00:00:00 | [PHONE]
711303 |  | 2020-11-09 00:00:00 | 2021-01-18 00:00:00 | [PHONE]
711418 |  | 2020-11-17 00:00:00 | 2021-01-16 00:00:00 | [PHONE]
711418 |  | 2021-02-09 00:00:00 | 2021-02-22 00:00:00 | [PHONE]
711424 |  | 2020-09-30 00:00:00 | 2021-01-02 00:00:00 | [PHONE]
711973 |  | 2021-01-04 00:00:00 | 2021-04-03 00:00:00 | [PHONE]
713135 |  | 2020-12-31 00:00:00 | 2021-03-11 00:00:00 | [PHONE]
713728 |  | 2021-02-17 00:00:00 | 2021-04-28 00:00:00 | [PHONE]
714859 |  | 2020-11-30 00:00:00 | 2021-01-05 00:00:00 | [PHONE]
715036 |  | 2021-03-26 00:00:00 | 2021-04-30 00:00:00 | [PHONE]
715979 |  | 2020-12-30 00:00:00 | 2021-01-18 00:00:00 | [PHONE]
716187 |  | 2021-02-23 00:00:00 | 2021-04-10 00:00:00 | [PHONE]
716513 |  | 2021-02-07 00:00:00 | 2021-03-13 00:00:00 | [PHONE]
716878 |  | 2020-12-14 00:00:00 | 2021-01-24 00:00:00 | [PHONE]
717139 |  | 2021-03-06 00:00:00 | 2021-04-22 00:00:00 | [PHONE]
718527 |  | 2021-04-18 00:00:00 | 2021-05-08 00:00:00 | [PHONE]
718866 |  | 2021-02-23 00:00:00 | 2021-03-24 00:00:00 | [PHONE]
719192 |  | 2021-01-09 00:00:00 | 2021-01-14 00:00:00 | [PHONE]
719208 |  | 2021-02-19 00:00:00 | 2021-02-28 00:00:00 | [PHONE]
719208 |  | 2021-03-10 00:00:00 | 2021-03-21 00:00:00 | [PHONE]
719772 |  | 2021-03-30 00:00:00 | 2021-04-08 00:00:00 | [PHONE]
719823 |  | 2021-02-22 00:00:00 | 2021-04-10 00:00:00 | [PHONE]
720448 |  | 2021-02-25 00:00:00 | 2021-04-14 00:00:00 | [PHONE]
720462 |  | 2021-03-07 00:00:00 | 2021-03-21 00:00:00 | [PHONE]
720592 |  | 2021-03-10 00:00:00 | 2021-05-09 00:00:00 | [PHONE]
723824 |  | 2021-03-16 00:00:00 | 2021-04-18 00:00:00 | [PHONE]
724238 |  | 2021-02-14 00:00:00 | 2021-03-15 00:00:00 | [PHONE]