Spreadsheet: 802066d1666622380-find-the-next-nearest-date-with-condition-example-worksheet
Sheet: Date range 1

Name | Date | Next nearest date
70040170 | 2022-02-11 00:00:00 | 2022-02-11 00:00:00
70040170 | 2022-06-23 00:00:00 | 2022-06-23 00:00:00
300008192 | 2022-03-01 00:00:00 | 2022-03-01 00:00:00
300008192 | 2022-04-08 00:00:00 | 2022-04-13 00:00:00
300008192 | 2022-04-29 00:00:00
300008192 | 2022-06-01 00:00:00
400007074 | 2021-12-29 00:00:00
400007074 | 2021-12-29 00:00:00
400007149 | 2022-02-04 00:00:00
400009147 | 2022-02-03 00:00:00
400009175 | 2022-03-10 00:00:00
400009175 | 2022-03-17 00:00:00
400009175 | 2022-03-30 00:00:00
400009175 | 2022-03-30 00:00:00
400009175 | 2022-04-07 00:00:00
400009175 | 2022-02-17 00:00:00
400009175 | 2022-03-31 00:00:00
400012195 | 2022-03-16 00:00:00
400012195 | 2022-03-16 00:00:00
400012195 | 2022-04-20 00:00:00
400012195 | 2022-05-18 00:00:00
400012195 | 2022-04-27 00:00:00
440005135 | 2022-03-27 00:00:00
440005154 | 2022-03-06 00:00:00
540001035 | 2021-11-11 00:00:00
540001035 | 2022-01-20 00:00:00
540001035 | 2022-01-06 00:00:00
540001035 | 2021-10-21 00:00:00
540001035 | 2022-02-10 00:00:00
540001105 | 2022-01-17 00:00:00
540001105 | 2022-01-03 00:00:00
540001105 | 2022-01-10 00:00:00
540001105 | 2022-01-20 00:00:00
540001105 | 2022-02-11 00:00:00
540004156 | 2022-04-19 00:00:00
540004156 | 2022-05-04 00:00:00
540004156 | 2022-05-04 00:00:00
540004223 | 1 Apr 2022
540004223 | 2022-07-01 00:00:00
540004223 | 2022-04-20 00:00:00
540004223 | 2022-04-27 00:00:00
540004223 | 2022-07-01 00:00:00
2160001180 | 2022-03-07 00:00:00
2160001180 | 2022-03-07 00:00:00
2160001180 | 2022-03-09 00:00:00
2160001180 | 2022-03-09 00:00:00
2160001180 | 2022-03-11 00:00:00
2160001180 | 2022-03-14 00:00:00
2160001180 | 2022-03-14 00:00:00
2160001180 | 2022-03-07 00:00:00
2160001180 | 2022-04-04 00:00:00
2160001180 | 2022-04-18 00:00:00
2160001180 | 2022-05-01 00:00:00
2160001180 | 2022-05-26 00:00:00
2160001180 | 2022-05-04 00:00:00
2160001180 | 2022-04-25 00:00:00
2160001180 | 2022-06-06 00:00:00
2160001180 | 2022-06-01 00:00:00
2160001186 | 2022-03-10 00:00:00
2160001186 | 2022-03-10 00:00:00
2160001186 | 2022-03-10 00:00:00
2160001186 | 2022-04-01 00:00:00
2160001186 | 2022-03-30 00:00:00
2160001186 | 2022-04-27 00:00:00
2160001186 | 2022-06-15 00:00:00
2160001186 | 2022-03-10 00:00:00
2160001186 | 2022-04-01 00:00:00
2160001186 | 2022-04-01 00:00:00
2160001186 | 2022-04-08 00:00:00
2160001186 | 2022-05-13 00:00:00
2160001186 | 2022-05-27 00:00:00
2160001186 | 2022-05-27 00:00:00
2160001186 | 2022-06-10 00:00:00
2160001186 | 2022-06-10 00:00:00
2160001186 | 2022-07-01 00:00:00
2160001186 | 2022-07-11 00:00:00
2160001186 | 2022-07-29 00:00:00
2160001186 | 2022-08-12 00:00:00
2160001193 | 2022-03-01 00:00:00
2160001193 | 2022-03-01 00:00:00
2160001193 | 2022-04-05 00:00:00
2160001193 | 2022-04-19 00:00:00
2160001193 | 2022-05-04 00:00:00
2160001193 | 2022-05-10 00:00:00
2160001193 | 2022-05-18 00:00:00
2160001193 | 2022-05-29 00:00:00
2160001193 | 2022-05-31 00:00:00
2160001193 | 2022-05-31 00:00:00
2160001193 | 2022-05-31 00:00:00
2160001193 | 2022-06-15 00:00:00
2160001193 | 2022-05-16 00:00:00
2160001193 | 2022-03-01 00:00:00
2160001193 | 2022-04-05 00:00:00
2160001193 | 2022-06-08 00:00:00
2160001193 | 2022-07-12 00:00:00
2160001193 | 2022-08-09 00:00:00
2160001193 | 2022-08-09 00:00:00
2160001194 | 2022-03-08 00:00:00
2160001209 | 2022-03-10 00:00:00
2160001209 | 2022-03-10 00:00:00
2160001209 | 2022-04-08 00:00:00
2160001209 | 2022-04-15 00:00:00
2160001209 | 2022-05-13 00:00:00
2160001209 | 2022-05-20 00:00:00
2160001209 | 2022-04-08 00:00:00
2160001209 | 2022-03-10 00:00:00
2160001209 | 2022-05-13 00:00:00
2160001209 | 2022-05-20 00:00:00
2160001209 | 2022-05-27 00:00:00
2160001209 | 2022-05-27 00:00:00
2160001209 | 2022-07-09 00:00:00
2160001209 | 2022-07-11 00:00:00
2160001209 | 2022-08-19 00:00:00
2160001209 | 2022-07-06 00:00:00
2160001209 | 2022-07-06 00:00:00
2160001209 | 2022-07-11 00:00:00
2160001209 | 2022-07-11 00:00:00
2160001209 | 2022-05-27 00:00:00
2160001209 | 2022-06-10 00:00:00
2160001209 | 2022-06-24 00:00:00
2160001209 | 2022-07-22 00:00:00
2160001209 | 2022-07-22 00:00:00
2160001209 | 2022-08-05 00:00:00
2160001209 | 2022-08-12 00:00:00
2160001209 | 2022-09-02 00:00:00
2160001216 | 2022-03-15 00:00:00
2160001216 | 2022-03-15 00:00:00
2160001216 | 2022-03-15 00:00:00
2160001216 | 2022-04-05 00:00:00
2160001216 | 2022-04-12 00:00:00
2160001216 | 2022-04-19 00:00:00
2160001216 | 2022-03-15 00:00:00
2160001216 | 2022-05-04 00:00:00
2160001216 | 2022-05-17 00:00:00
2160001216 | 2022-05-23 00:00:00
2160001216 | 2022-06-08 00:00:00
2160001216 | 2022-03-29 00:00:00
2160001216 | 2022-03-29 00:00:00
2160001216 | 2022-03-15 00:00:00
2160001216 | 2022-03-29 00:00:00
2160001216 | 2022-03-15 00:00:00
2160001216 | 2022-03-15 00:00:00
2160001216 | 2022-07-17 00:00:00
2160001216 | 2022-06-27 00:00:00
2160001216 | 2022-05-17 00:00:00
2160001227 | 2022-03-17 00:00:00
2160001227 | 2022-04-13 00:00:00
2160001227 | 2022-04-16 00:00:00
2160001227 | 2022-04-17 00:00:00
2160001227 | 2022-05-05 00:00:00
2160001227 | 2022-05-09 00:00:00
2160001227 | 2022-05-12 00:00:00
2160001227 | 2022-04-07 00:00:00
2160001227 | 2022-04-07 00:00:00
2160001227 | 2022-06-23 00:00:00
2160001227 | 2022-05-17 00:00:00
2160001227 | 2022-06-15 00:00:00
2160001227 | 2022-06-30 00:00:00
2160001227 | 2022-07-12 00:00:00
2160001227 | 2022-05-05 00:00:00
2160001227 | 2022-06-09 00:00:00
2160001227 | 2022-04-07 00:00:00
2160001227 | 2022-04-14 00:00:00
2160001227 | 2022-06-02 00:00:00
2160001227 | 2022-06-30 00:00:00
2160001227 | 2022-07-07 00:00:00
2160001227 | 2022-08-04 00:00:00
2160001227 | 2022-08-11 00:00:00
2160001227 | 2022-08-18 00:00:00
2160001227 | 2022-04-21 00:00:00
2160001227 | 2022-09-08 00:00:00
2160001228 | 2022-03-31 00:00:00
2160001228 | 2022-07-14 00:00:00
2160001228 | 2022-03-28 00:00:00
2160001228 | 2022-05-05 00:00:00
2160001228 | 2022-03-17 00:00:00
2160001228 | 2022-05-19 00:00:00
2160001228 | 2022-05-19 00:00:00
2160001228 | 2022-06-02 00:00:00
2160001228 | 2022-06-30 00:00:00
2160001228 | 2022-07-21 00:00:00
2160001228 | 2022-07-28 00:00:00
2160001228 | 2022-08-11 00:00:00
2160001239 | 2022-03-22 00:00:00
2160001249 | 2022-03-28 00:00:00
2160001249 | 2022-05-15 00:00:00
2160001249 | 2022-06-17 00:00:00
2160001249 | 2022-06-17 00:00:00
2160001249 | 2022-03-28 00:00:00
2160001249 | 2022-03-28 00:00:00
2160001249 | 2022-04-25 00:00:00
2160001249 | 2022-05-09 00:00:00
2160001249 | 2022-06-06 00:00:00
2160001249 | 2022-06-13 00:00:00
2160001249 | 2022-08-01 00:00:00
2160001249 | 2022-07-04 00:00:00
2160001249 | 2022-04-18 00:00:00
2160001249 | 2022-05-04 00:00:00
2160001249 | 2022-07-26 00:00:00
2160001249 | 2022-08-22 00:00:00
2160001249 | 2022-08-22 00:00:00
2160001249 | 2022-08-29 00:00:00
2160001249 | 2022-05-16 00:00:00
2160002214 | 2022-03-28 00:00:00
2160002214 | 2022-04-04 00:00:00
2160002214 | 2022-04-15 00:00:00
2160002214 | 2022-04-20 00:00:00
2160002214 | 2022-03-22 00:00:00
2160002214 | 2022-09-08 00:00:00
3590017053 | 2021-11-09 00:00:00
3590017053 | 2021-11-30 00:00:00
3590017053 | 2021-12-29 00:00:00
3590017053
3590017053 | 2022-02-15 00:00:00
3590017053 | 2022-01-25 00:00:00
3590017053 | 2022-05-11 00:00:00
3590017053 | 2021-12-29 00:00:00
3590017070 | 2022-04-02 00:00:00
3590017070 | 2021-12-14 00:00:00
3590017171 | 2022-02-15 00:00:00
9620001243 | 2022-04-01 00:00:00
9950007002 | 2020-12-28 00:00:00
9950007002 | 2020-12-28 00:00:00
9950007002 | 2020-12-28 00:00:00
9950007002
9950007225 | 2022-03-17 00:00:00
9950009001 | 2021-01-14 00:00:00