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

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