Spreadsheet: 120436d1315296804-macro-to-identify-and-highlight-dates-less-than-21-days-from-today-s-date-swj
Sheet: Sheet1

Date | Time | Code | Version
2011-10-12 00:00:00 | 13:51:55 | RGD2212382 | 4545
2011-10-24 00:00:00 | 17:50:52 | RGD2212382 | 6441
2011-08-21 00:00:00 | 10:46:52 | RGD2212496 | 6432
2011-09-13 00:00:00 | 22:17:06 | [NAME] | 1234
2011-11-19 00:00:00 | 09:07:08 | [NAME] | 6445
2011-10-19 00:00:00 | 16:23:25 | RGD2212764 | 6441
2011-10-20 00:00:00 | 17:02:14 | [NAME] | 6441
2011-11-02 00:00:00 | 08:54:56 | RGD2586120 | 6441
2011-08-22 00:00:00 | 14:23:34 | RGD2586175 | 6432
2011-08-07 00:00:00 | 15:14:14 | RGD2586222 | 6419
2011-10-15 00:00:00 | 14:51:29 | RGD2586237 | 6441
2011-09-14 00:00:00 | 07:36:42 | RGD2586294 | 6436
2011-10-28 00:00:00 | 01:55:53 | RGD2586346 | 6441
2011-09-21 00:00:00 | 16:36:38 | RGD2586412 | 6436
2011-10-04 00:00:00 | 14:10:25 | RGD2586824 | 6440
2011-08-09 00:00:00 | 07:58:23 | RGD2586828 | 6424
2011-09-07 00:00:00 | 18:14:45 | RGD2586879 | 6434
2011-10-10 00:00:00 | 12:58:07 | RGD2587041 | 6441
2011-08-19 00:00:00 | 12:01:41 | RGD2587042 | 6399
2011-09-25 00:00:00 | 10:18:02 | RGD2587043 | 6439
2011-09-16 00:00:00 | 07:52:08 | [NAME] | 6436
2011-09-17 00:00:00 | 08:01:39 | RGD2587054 | 6436
2011-08-25 00:00:00 | 08:37:49 | RGD2587071 | 6401
2011-09-15 00:00:00 | 07:49:17 | RGD2587210 | 6436
2011-08-30 00:00:00 | 11:52:06 | RGD2591279 | 6434
2011-09-24 00:00:00 | 03:12:10 | RGD2591896 | 6439
2011-10-26 00:00:00 | 21:08:39 | RGD2591911 | 6441
2011-10-02 00:00:00 | 09:39:25 | RGD2592446 | 6440
2011-10-13 00:00:00 | 14:39:22 | RGD2592478 | 6441
2011-10-23 00:00:00 | 17:47:25 | RGD2592497 | 6441
2011-10-16 00:00:00 | 15:17:08 | RGD2592565 | 6441
2011-11-11 00:00:00 | 16:03:32 | RGD2592604 | 6442
2011-11-01 00:00:00 | 08:46:42 | RGD2592647 | 6442
2011-11-06 00:00:00 | 15:02:52 | [NAME] | 6442
2011-08-14 00:00:00 | 15:53:25 | RGD2592774
2011-09-19 00:00:00 | 11:03:02 | [NAME] | 6438
2011-08-13 00:00:00 | 13:26:46 | RGD2592892 | 6427
2011-11-04 00:00:00 | 13:59:34 | RGD2592901 | 6442
2011-11-14 00:00:00 | 17:23:54 | RGD3038236 | 6442
2011-09-01 00:00:00 | 13:59:16 | RGD3038333 | 6434
2011-08-24 00:00:00 | 15:14:43 | [NAME] | 6428
2011-11-07 00:00:00 | 15:21:43 | RGD3038453 | 6442
2011-08-29 00:00:00 | 08:52:25 | RGD3038459 | 6434
2011-08-12 00:00:00 | 09:23:59 | RGD3038546 | 6427
2011-09-11 00:00:00 | 13:48:43 | RGD3038548 | 6435
2011-10-05 00:00:00 | 14:18:14 | RGD3038557 | 6440
2011-09-20 00:00:00 | 13:57:19 | RGD3038733 | 6438
2011-08-11 00:00:00 | 16:05:59 | RGD3038761 | 6424
2011-08-26 00:00:00 | 14:02:30 | RGD3038800 | 6433
2011-08-23 00:00:00 | 14:45:42 | RGD3038801 | 6432
2011-10-17 00:00:00 | 15:38:54 | RGD3038930 | 6441
2011-09-02 00:00:00 | 14:18:33 | [NAME] | 6434
2011-09-03 00:00:00 | 16:24:02 | RGD3039002 | 6434
2011-08-02 00:00:00 | 13:40:43 | RGD3039003 | 6418
2011-10-06 00:00:00 | 15:59:57 | RGD3039082 | 6440
2011-08-16 00:00:00 | 18:58:01 | RGD3039111 | 6427
2011-11-05 00:00:00 | 14:27:25 | RGL2209220 | 6442
2011-08-20 00:00:00 | 13:28:22 | RGL2209244 | 6428
2011-11-10 00:00:00 | 15:59:52 | RGL2209248 | 6442
2011-10-03 00:00:00 | 13:26:57 | RGL2209254 | 6440
2011-11-03 00:00:00 | 13:58:04 | RGL2209262 | 6442
2011-11-15 00:00:00 | 17:43:38 | RGL2209338 | 6442
2011-10-09 00:00:00 | 20:09:00 | RGL2209344 | 6440
2011-09-22 00:00:00 | 16:57:36 | RGL2209349 | 6438
2011-08-04 00:00:00 | 10:48:36 | RGL2209352
2011-10-25 00:00:00 | 20:45:31 | RGL2209354 | 6433
2011-08-08 00:00:00 | 18:49:11 | RGL2209374 | 6420
2011-10-29 00:00:00 | 08:29:25 | RGL2209387 | 6442
2011-10-11 00:00:00 | 13:28:11 | RGL2209397 | 6441
2011-10-30 00:00:00 | 08:31:08 | [NAME] | 6442
2011-10-27 00:00:00 | 23:46:17 | RGL2209402 | 6441
2011-11-12 00:00:00 | 16:06:07 | RGL2209403 | 6442
2011-11-18 00:00:00 | 18:32:15 | RGL2209412 | 6442
2011-09-29 00:00:00 | 16:21:11 | RGL2209417 | 6439
2011-09-05 00:00:00 | 17:39:49 | RGL2209418 | 6434
2011-10-14 00:00:00 | 14:49:57 | RGL2209420 | 6441
2011-10-08 00:00:00 | 19:43:04 | RGL2209440 | 6428
2011-09-06 00:00:00 | 18:13:44 | RGL2586453 | 6434
2011-09-08 00:00:00 | 12:08:41 | RGL2586628 | 6420
2011-09-23 00:00:00 | 20:58:13 | [NAME] | 6438
2011-11-09 00:00:00 | 15:40:36 | RGL2586675 | 6442
2011-09-18 00:00:00 | 19:08:42 | [NAME] | 6436
2011-10-31 00:00:00 | 08:33:14 | RGL2586820 | 6442
2011-09-09 00:00:00 | 12:09:24 | RGL2586905 | 6435
2011-08-03 00:00:00 | 17:00:45 | RGL2586925 | 6418
2011-09-10 00:00:00 | 12:20:21 | RGL2587363 | 6435
2011-10-21 00:00:00 | 17:15:31 | [NAME] | 6441
2011-08-06 00:00:00 | 11:49:53 | [NAME] | 6419
2011-09-28 00:00:00 | 15:50:55 | RGL2591091 | 6439
2011-10-07 00:00:00 | 16:03:40 | [NAME] | 6404
2011-09-04 00:00:00 | 16:38:27 | RGL2592309 | 6434
2011-10-18 00:00:00 | 16:09:27 | RGL2592323 | 6441
2011-10-22 00:00:00 | 17:35:34 | RGL2592397 | 6441
2011-08-10 00:00:00 | 10:29:24 | RGL2592403 | 6414
2011-09-30 00:00:00 | 16:35:04 | RGL2592433 | 6439
2011-09-27 00:00:00 | 15:17:03 | RGL2592615 | 6417
2011-11-13 00:00:00 | 16:27:30 | RGL2592617 | 6442
2011-09-12 00:00:00 | 20:18:10 | RGL2592638 | 6435
2011-11-17 00:00:00 | 18:11:10 | RGL2592784 | 6442
2011-10-01 00:00:00 | 05:59:44 | RGL2592798 | 6440
2011-08-05 00:00:00 | 10:56:14 | RGL2592804 | 6419
2011-08-01 00:00:00 | 15:47:15 | RGL2592809 | 6417
2011-08-15 00:00:00 | 18:25:14 | RGL2592825 | 6427
2011-09-26 00:00:00 | 13:17:42 | [NAME] | 6439
2011-08-31 00:00:00 | 13:06:39 | RGL2592846 | 6434
2011-08-28 00:00:00 | 17:01:03 | RGL3039146 | 6433
2011-11-16 00:00:00 | 18:01:18 | RGL3039149 | 6442
2011-08-27 00:00:00 | 16:08:26 | [NAME] | 6433
2011-11-08 00:00:00 | 15:37:03 | RGL3039161 | 6442
2011-08-17 00:00:00 | 23:16:00 | RGL3039168 | 6421
2011-08-18 00:00:00 | 10:41:26 | RGL3039178 | 6428