Spreadsheet: 868659d1715336881-pull-out-specific-date-based-on-criteria-from-multiple-columns-having-dates-service-due-date-calculation-sample
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Month | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Year | 2024
Asset ID | Date of Next service Expected (1st Service) | Date of Next service Expected (2nd Service) | Date of Next service Expected (3rd Service) | Date of Next service Expected (4th Service) | Date of Next service Expected (5th Service) | Date of Next service Expected (6th Service) | Date of Next service Expected (7th Service) | Date of Next service Expected (8th Service) | Date of Next service Expected (9th Service) | Date of Next service Expected (10th Service) | Date of Next service Expected (11th Service) | Date of Next service Expected (12th Service) | Date of Next service Expected (13th Service) | Date of Next service Expected (14th Service) | Date of Next service Expected (15th Service)
AA1 | 2024-05-13 23:05:21.951000 | 2024-12-05 22:10:43.902000 | 2025-06-29 21:16:05.854000 | 2026-01-21 20:21:27.805000 | 2026-08-15 19:26:49.756000 | 2027-03-09 18:32:11.707000 | 2027-10-01 17:37:33.659000 | 2028-04-24 16:42:55.610000 | 2028-11-16 15:48:17.561000 | 2029-06-10 14:53:39.512000 | 2030-01-02 13:59:01.463000 | 2030-07-27 13:04:23.415000 | 2031-02-18 12:09:45.366000 | 2031-09-12 11:15:07.317000 | 2032-04-05 10:20:29.268000
AA2 | 2024-01-19 20:06:04.314000 | 2024-05-20 16:12:08.628000 | 2024-09-19 12:18:12.943000 | 2025-01-19 08:24:17.257000 | 2025-05-21 04:30:21.571000 | 2025-09-20 00:36:25.885000 | 2026-01-19 20:42:30.200000 | 2026-05-21 16:48:34.514000 | 2026-09-20 12:54:38.828000 | 2027-01-20 09:00:43.142000 | 2027-05-22 05:06:47.457000 | 2027-09-21 01:12:51.771000 | 2028-01-20 21:18:56.085000 | 2028-05-21 17:25:00.399000 | 2028-09-20 13:31:04.714000
AA3 | 2024-07-24 12:28:03 | 2025-03-01 00:56:06.234000 | 2025-12-06 13:24:09.351000 | 2026-09-13 01:52:12.468000 | 2027-06-20 14:20:15.584000 | 2028-03-27 02:48:18.701000 | 2029-01-01 15:16:21.818000 | 2029-10-09 03:44:24.935000 | 2030-07-16 16:12:28.052000 | 2031-04-23 04:40:31.169000 | 2032-01-28 17:08:34.286000 | 2032-11-04 05:36:37.403000 | 2033-08-11 18:04:40.519000 | 2034-05-19 06:32:43.636000 | 2035-02-23 19:00:46.753000 |  | -
AA4 | 2023-11-25 00:00:00 | 2024-05-23 00:00:00 | 2024-11-19 00:00:00 | 2025-05-18 00:00:00 | 2025-11-14 00:00:00 | 2026-05-13 00:00:00 | 2026-11-09 00:00:00 | 2027-05-08 00:00:00 | 2027-11-04 00:00:00 | 2028-05-02 00:00:00 | 2028-10-29 00:00:00 | 2029-04-27 00:00:00 | 2029-10-24 00:00:00 | 2030-04-22 00:00:00 | 2030-10-19 00:00:00
AA5 | 2023-06-20 04:23:26.750000 | 2023-12-06 08:46:53.499000 | 2024-05-23 13:10:20.249000 | 2024-11-08 17:33:46.998000 | 2025-04-26 21:57:13.748000 | 2025-10-13 02:20:40.497000 | 2026-03-31 06:44:07.247000 | 2026-09-16 11:07:33.996000 | 2027-03-04 15:31:00.746000 | 2027-08-20 19:54:27.496000 | 2028-02-06 00:17:54.245000 | 2028-07-24 04:41:20.995000 | 2029-01-09 09:04:47.744000 | 2029-06-27 13:28:14.494000 | 2029-12-13 17:51:41.243000
AA6 | 2023-07-30 10:18:03.612000 | 2024-05-20 20:36:07.224000 | 2025-03-12 06:54:10.836000 | 2026-01-01 17:12:14.448000 | 2026-10-24 03:30:18.060000 | 2027-08-15 13:48:21.672000 | 2028-06-06 00:06:25.284000 | 2029-03-28 10:24:28.896000 | 2030-01-17 20:42:32.508000 | 2030-11-09 07:00:36.120000 | 2031-08-31 17:18:39.732000 | 2032-06-22 03:36:43.344000 | 2033-04-13 13:54:46.957000 | 2034-02-03 00:12:50.569000 | 2034-11-25 10:30:54.181000
AA7 | 2023-03-26 18:34:21.344000 | 2023-10-25 13:08:42.688000 | 2024-08-25 07:43:04 | 2024-12-24 02:17:25.377000 | 2025-07-24 20:51:46.721000 | 2026-02-22 15:26:08.065000 | 2026-09-23 10:00:29.410000 | 2027-04-24 04:34:50.754000 | 2027-11-22 23:09:12.098000 | 2028-06-22 17:43:33.442000 | 2029-01-21 12:17:54.786000 | 2029-08-22 06:52:16.131000 | 2030-03-23 01:26:37.475000 | 2030-10-21 20:00:58.819000 | 2031-05-22 14:35:20.163000 |  | -
AA8 | 2022-11-06 18:45:11.529000 | 2023-03-22 13:30:23.057000 | 2023-08-05 08:15:34.586000 | 2023-12-19 03:00:46.114000 | 2024-05-02 21:45:57.643000 | 2024-09-15 16:31:09.172000 | 2025-01-29 11:16:20.700000 | 2025-06-14 06:01:32.229000 | 2025-10-28 00:46:43.757000 | 2026-03-12 19:31:55.286000 | 2026-07-26 14:17:06.815000 | 2026-12-09 09:02:18.343000 | 2027-04-24 03:47:29.872000 | 2027-09-06 22:32:41.401000 | 2028-01-20 17:17:52.929000
AA9 | 2023-02-02 22:37:28.711000 | 2023-09-20 21:14:57.421000 | 2024-05-07 19:52:26.132000 | 2024-12-23 18:29:54.842000 | 2025-08-10 17:07:23.553000 | 2026-03-28 15:44:52.264000 | 2026-11-13 14:22:20.974000 | 2027-07-01 12:59:49.685000 | 2028-02-16 11:37:18.395000 | 2028-10-03 10:14:47.106000 | 2029-05-21 08:52:15.817000 | 2030-01-06 07:29:44.527000 | 2030-08-24 06:07:13.238000 | 2031-04-11 04:44:41.948000 | 2031-11-27 03:22:10.659000
AA10 | 2022-11-16 08:21:12.928000 | 2023-05-12 16:42:25.856000 | 2023-11-06 01:03:38.785000 | 2024-05-01 09:24:51.713000 | 2024-10-25 17:46:04.641000 | 2025-04-21 02:07:17.569000 | 2025-10-15 10:28:30.497000 | 2026-04-10 18:49:43.425000 | 2026-10-05 03:10:56.354000 | 2027-03-31 11:32:09.282000 | 2027-09-24 19:53:22.210000 | 2028-03-20 04:14:35.138000 | 2028-09-13 12:35:48.066000 | 2029-03-09 20:57:00.994000 | 2029-09-03 05:18:13.923000