Spreadsheet: 760205d1640063071-how-to-find-a-date-if-it-falls-between-a-range-of-date-dummy
Sheet: Sheet1

SUBJID | V3 | V4 | V5 | V6 | V7 | V8 | V9 | V10 | V11 | V12 | V13 | V14 | V15 | V16 | V17 | V18 | V19 | V20 | V21 | V99 | V101 | V102 | V103 | V104 | V105 | V801
1001 | 2019-12-17 00:00:00 | 2020-01-13 00:00:00 | 2020-02-10 00:00:00 | 2020-03-09 00:00:00 | 2020-04-08 00:00:00 | 2020-05-06 00:00:00 | 2020-06-04 00:00:00 | 2020-07-01 00:00:00 | 2020-07-29 00:00:00 | 2020-08-25 00:00:00 | 2020-09-22 00:00:00 | 2020-10-21 00:00:00 | 2020-11-17 00:00:00 | 2020-12-17 00:00:00 | 2021-01-14 00:00:00 | 2021-02-08 00:00:00 | 2021-03-09 00:00:00 | 2021-04-06 00:00:00 | 2021-05-04 00:00:00 |  |  |  |  |  |  | 2021-06-01 00:00:00
1002
1003
1004 | 2019-12-17 00:00:00 | 2020-01-14 00:00:00 | 2020-02-11 00:00:00 | 2020-03-10 00:00:00 | 2020-04-07 00:00:00 | 2020-05-05 00:00:00 | 2020-06-03 00:00:00 | 2020-06-30 00:00:00 | 2020-07-28 00:00:00 | 2020-08-25 00:00:00 | 2020-09-22 00:00:00 | 2020-10-21 00:00:00 | 2020-11-17 00:00:00 | 2020-12-15 00:00:00 | 2021-01-12 00:00:00 | 2021-02-09 00:00:00 | 2021-03-09 00:00:00 | 2021-04-08 00:00:00 | 2021-05-06 00:00:00 |  |  |  |  |  |  | 2021-07-06 00:00:00
1005 | 2019-12-19 00:00:00 | 2020-01-17 00:00:00 | 2020-02-13 00:00:00 | 2020-03-12 00:00:00 | 2020-04-09 00:00:00 | 2020-05-07 00:00:00 | 2020-06-04 00:00:00 | 2020-07-06 00:00:00 | 2020-08-03 00:00:00 | 2020-08-27 00:00:00 | 2020-09-28 00:00:00 | 2020-10-27 00:00:00 | 2020-11-17 00:00:00 | 2020-12-17 00:00:00 | 2021-01-14 00:00:00 | 2021-02-09 00:00:00 | 2021-03-09 00:00:00 | 2021-04-08 00:00:00 | 2021-05-05 00:00:00 |  |  |  |  |  |  | 2021-06-28 00:00:00
1006 | 2019-12-19 00:00:00 | 2020-01-14 00:00:00 | 2020-02-11 00:00:00 | 2020-03-10 00:00:00 | 2020-04-08 00:00:00 | 2020-05-05 00:00:00 | 2020-06-02 00:00:00 | 2020-06-30 00:00:00 | 2020-07-28 00:00:00 | 2020-08-25 00:00:00 | 2020-09-22 00:00:00 | 2020-10-22 00:00:00 | 2020-11-19 00:00:00 | 2020-12-17 00:00:00 | 2021-01-14 00:00:00 | 2021-02-11 00:00:00 | 2021-03-15 00:00:00 | 2021-04-09 00:00:00 | 2021-05-04 00:00:00 |  | 2021-06-25 00:00:00 | 2021-08-05 00:00:00 | 2021-09-16 00:00:00 | 2021-11-04 00:00:00
1007 | 2019-12-20 00:00:00 | 2020-01-20 00:00:00 | 2020-02-18 00:00:00 | 2020-03-17 00:00:00 | 2020-04-10 00:00:00 | 2020-05-12 00:00:00 | 2020-06-08 00:00:00 | 2020-07-02 00:00:00 | 2020-07-31 00:00:00 | 2020-09-04 00:00:00 | 2020-09-25 00:00:00 | 2020-10-23 00:00:00 | 2020-11-20 00:00:00 | 2020-12-18 00:00:00 | 2021-01-15 00:00:00 | 2021-02-16 00:00:00 | 2021-03-12 00:00:00 | 2021-04-09 00:00:00 | 2021-05-07 00:00:00 |  |  |  |  |  |  | 2021-06-04 00:00:00
1008 | 2019-12-19 00:00:00 | 2020-01-13 00:00:00 | 2020-02-10 00:00:00 | 2020-03-09 00:00:00 | 2020-04-06 00:00:00 | 2020-05-04 00:00:00 | 2020-06-01 00:00:00 | 2020-06-29 00:00:00 | 2020-07-27 00:00:00 | 2020-08-25 00:00:00 | 2020-09-22 00:00:00 | 2020-10-22 00:00:00 | 2020-11-16 00:00:00 | 2020-12-17 00:00:00 | 2021-01-13 00:00:00 | 2021-02-08 00:00:00 | 2021-03-11 00:00:00 | 2021-04-08 00:00:00 | 2021-05-19 00:00:00 |  |  |  |  |  |  | 2021-06-14 00:00:00
1009 | 2019-12-24 00:00:00 | 2020-01-21 00:00:00 | 2020-02-18 00:00:00 | 2020-03-20 00:00:00 | 2020-04-14 00:00:00 | 2020-05-12 00:00:00 | 2020-06-09 00:00:00 | 2020-07-07 00:00:00 | 2020-08-04 00:00:00 | 2020-09-01 00:00:00 | 2020-09-29 00:00:00 | 2020-10-27 00:00:00 | 2020-11-24 00:00:00 | 2020-12-22 00:00:00 | 2021-01-19 00:00:00 | 2021-02-23 00:00:00 | 2021-03-16 00:00:00 | 2021-04-13 00:00:00 | 2021-05-18 00:00:00 |  | 2021-06-22 00:00:00 | 2021-08-10 00:00:00 | 2021-09-22 00:00:00 | 2021-11-09 00:00:00
1010 | 2019-12-20 00:00:00 | 2020-01-17 00:00:00 | 2020-02-14 00:00:00 | 2020-03-13 00:00:00 | 2020-04-08 00:00:00 | 2020-05-06 00:00:00 | 2020-06-03 00:00:00 | 2020-07-01 00:00:00 | 2020-07-29 00:00:00 | 2020-08-26 00:00:00 | 2020-09-23 00:00:00 | 2020-10-22 00:00:00 | 2020-11-18 00:00:00 | 2020-12-17 00:00:00 | 2021-01-12 00:00:00 | 2021-02-09 00:00:00 | 2021-03-10 00:00:00 | 2021-04-08 00:00:00 | 2021-05-05 00:00:00 |  | 2021-06-17 00:00:00 | 2021-07-28 00:00:00 | 2021-09-16 00:00:00 | 2021-11-03 00:00:00 | 2021-12-15 00:00:00