Spreadsheet: 839258d1691768404-how-to-populate-the-closest-date-match-to-the-reference-date-example
Sheet: Sheet1

Student IDs | Assessment Date
ID-1237 | 2017-12-21 00:00:00
ID-1237 | 2018-05-22 00:00:00
ID-1237 | 2018-09-28 00:00:00
ID-1237 | 2019-01-02 00:00:00
ID-1237 | 2019-04-10 00:00:00
ID-1237 | 2019-05-23 00:00:00
ID-1237 | 2019-08-14 00:00:00
ID-1237 | 2019-12-12 00:00:00
ID-1237 | 2020-03-03 00:00:00
ID-1237 | 2020-07-27 00:00:00
ID-1237 | 2020-11-11 00:00:00
ID-1237 | 2021-02-02 00:00:00
ID-1237 | 2021-05-04 00:00:00
ID-1237 | 2021-09-01 00:00:00
ID-1237 | 2021-12-13 00:00:00
ID-1237 | 2022-03-15 00:00:00
ID-1237 | 2022-07-06 00:00:00
ID-1237 | 2022-10-24 00:00:00
ID-1237 | 2022-12-07 00:00:00
ID-1237 | 2023-03-22 00:00:00
ID-1237 | 2023-07-26 00:00:00
ID-1235 | 2022-09-30 00:00:00
ID-1235 | 2023-01-09 00:00:00
ID-1240 | 2017-11-02 00:00:00
ID-1240 | 2018-12-07 00:00:00
ID-1240 | 2019-07-03 00:00:00
ID-1240 | 2019-12-12 00:00:00
ID-1240 | 2020-04-15 00:00:00
ID-1240 | 2020-07-02 00:00:00
ID-1240 | 2020-10-20 00:00:00
ID-1240 | 2021-01-15 00:00:00
ID-1240 | 2021-05-17 00:00:00
ID-1240 | 2021-08-04 00:00:00
ID-1240 | 2021-10-11 00:00:00
ID-1240 | 2021-12-24 00:00:00
ID-1240 | 2022-02-16 00:00:00
ID-1240 | 2022-02-28 00:00:00
ID-1240 | 2022-06-22 00:00:00
ID-1240 | 2022-09-12 00:00:00
ID-1240 | 2022-12-12 00:00:00
ID-1240 | 2023-02-23 00:00:00
ID-1240 | 2023-05-30 00:00:00
ID-1234 | 2017-11-15 00:00:00
ID-1234 | 2018-01-25 00:00:00
ID-1234 | 2018-05-16 00:00:00
ID-1234 | 2018-09-05 00:00:00
ID-1234 | 2018-11-15 00:00:00
ID-1234 | 2019-02-19 00:00:00
ID-1234 | 2019-05-01 00:00:00
ID-1234 | 2019-10-15 00:00:00
ID-1234 | 2020-01-20 00:00:00
ID-1234 | 2020-04-14 00:00:00
ID-1234 | 2020-07-08 00:00:00
ID-1234 | 2020-09-15 00:00:00
ID-1234 | 2020-11-06 00:00:00
ID-1234 | 2021-03-04 00:00:00
ID-1234 | 2021-05-17 00:00:00
ID-1234 | 2021-10-12 00:00:00
ID-1234 | 2022-02-24 00:00:00
ID-1234 | 2022-03-22 00:00:00
ID-1234 | 2022-08-23 00:00:00
ID-1234 | 2022-09-27 00:00:00
ID-1234 | 2023-02-09 00:00:00
ID-1244 | 2021-07-12 00:00:00
ID-1244 | 2021-10-06 00:00:00
ID-1244 | 2021-12-21 00:00:00
ID-1244 | 2022-01-12 00:00:00
ID-1244 | 2022-06-01 00:00:00
ID-1244 | 2022-08-18 00:00:00
ID-1244 | 2022-12-19 00:00:00
ID-1244 | 2023-04-27 00:00:00
ID-1244 | 2023-07-05 00:00:00
ID-1241 | 2022-06-09 00:00:00
ID-1241 | 2022-06-28 00:00:00
ID-1241 | 2022-09-09 00:00:00
ID-1241 | 2022-11-18 00:00:00
ID-1241 | 2023-01-13 00:00:00
ID-1241 | 2023-04-28 00:00:00
ID-1241 | 2023-07-14 00:00:00
ID-1236 | 2017-12-22 00:00:00
ID-1236 | 2018-03-15 00:00:00
ID-1236 | 2018-08-01 00:00:00
ID-1236 | 2018-10-02 00:00:00
ID-1236 | 2019-01-22 00:00:00
ID-1236 | 2019-05-08 00:00:00
ID-1236 | 2019-09-04 00:00:00
ID-1236 | 2019-11-28 00:00:00
ID-1236 | 2020-05-22 00:00:00
ID-1236 | 2020-08-18 00:00:00
ID-1236 | 2020-11-26 00:00:00
ID-1236 | 2021-04-26 00:00:00
ID-1236 | 2021-06-10 00:00:00
ID-1236 | 2021-11-18 00:00:00
ID-1236 | 2022-02-08 00:00:00
ID-1236 | 2022-06-27 00:00:00
ID-1236 | 2022-07-05 00:00:00
ID-1236 | 2022-10-20 00:00:00
ID-1236 | 2023-04-17 00:00:00
ID-1239 | 2018-04-18 00:00:00
ID-1239 | 2019-05-28 00:00:00
ID-1239 | 2020-05-14 00:00:00
ID-1239 | 2020-07-22 00:00:00
ID-1239 | 2020-10-05 00:00:00
ID-1239 | 2020-12-29 00:00:00
ID-1239 | 2021-03-04 00:00:00
ID-1239 | 2021-06-01 00:00:00
ID-1239 | 2021-09-09 00:00:00
ID-1239 | 2021-12-06 00:00:00
ID-1239 | 2022-02-17 00:00:00
ID-1239 | 2022-05-30 00:00:00
ID-1239 | 2022-08-18 00:00:00
ID-1239 | 2022-06-14 00:00:00
ID-1239 | 2022-11-03 00:00:00
ID-1239 | 2023-02-03 00:00:00
ID-1239 | 2023-05-17 00:00:00
ID-1239 | 2023-06-27 00:00:00
ID-1238 | 2023-03-27 00:00:00
ID-1238 | 2023-05-18 00:00:00