Spreadsheet: 887508d1737732035-how-to-find-a-date-in-a-column-which-is-associated-to-a-value-without-decimals-projet
Sheet: Fichier Suivi TAS 

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ITD | ITD | ITD | ITD | ITD | ITD | ITD | ITD | ITD | ITD | ITD | ITD | ITD | ITD | ITD | ITD | ITD | ITD | ITD | ITD | ITD | ITD | ITD | ITD | ITD | ITD | ITD | ITD | ITD | ITD | ITD | ITD
 | x | x | x | x |  | x | x | x | x | x | x |  |  |  |  |  | x |  |  |  | x | x
 |  |  |  |  |  |  |  | PO Ref | PR Ref |  |  |  |  |  | PO life status | Date LI | Name | Phase |  | Item |  |  |  |  |  |  |  |  | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 | 2025-06-01 00:00:00 | 2025-07-01 00:00:00 | 2025-08-01 00:00:00 | 2025-09-01 00:00:00 | 2025-10-01 00:00:00 | 2025-11-01 00:00:00 | 2025-12-01 00:00:00 | 2026-01-01 00:00:00 | 2026-02-01 00:00:00 | 2026-03-01 00:00:00 | 2026-04-01 00:00:00 | 2026-05-01 00:00:00 | 2026-06-01 00:00:00 | 2026-07-01 00:00:00 | 2026-08-01 00:00:00 | 2026-09-01 00:00:00 | 2026-10-01 00:00:00 | 2026-11-01 00:00:00 | 2026-12-01 00:00:00 | 2027-01-01 00:00:00 | 2027-02-01 00:00:00 | 2027-03-01 00:00:00 | 2027-04-01 00:00:00 | 2027-05-01 00:00:00 | 2027-06-01 00:00:00 | 2027-07-01 00:00:00 | 2027-08-01 00:00:00 | 2027-09-01 00:00:00 | 2027-10-01 00:00:00 | 2027-11-01 00:00:00 | 2027-12-01 00:00:00
 |  |  |  |  |  |  |  | 4100004353 | [PHONE] |  |  |  |  |  | To close next termination contract | ? | PAT T | Phase 2 | Days | 00001 | 2024-02-01 00:00:00 | 2024-12-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22175 | 33706 | 37254 | 37254 | 35480 | 39028 | 28384 | 37254 |  | 37254 | 35511
 |  |  |  |  |  |  |  | 4100004353 |  |  |  |  |  |  | To close next termination contract |  |  |  | Missions | 00002 | 2024-02-01 00:00:00 | 2024-12-31 00:00:00 |  |  | 84393 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8877.19
 |  |  |  |  |  |  |  | 4100004353 | [PHONE] |  |  |  |  |  | To open |  | PAT T | Phase 2 | Days | 00003 | 2025-01-01 00:00:00 | 2025-05-30 00:00:00 |  |  | 195140 | 1774 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 27466 | 27466 | 27466 | 27466 | 27466
 |  |  |  |  |  |  |  | 4100004353 |  |  |  |  |  |  | To open |  |  |  | Missions | 00004 | 2025-01-01 00:00:00 | 2025-05-30 00:00:00 |  |  | 29271
 |  |  |  |  |  |  |  | 4100004388 | [PHONE] |  |  |  |  |  | To close next termination contract |  | LE CHAUVE G | Phase 2 | Days | 00001 | 2024-01-09 00:00:00 | 2025-01-07 00:00:00 |  |  | 431739 | 1869 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 39249 |  | 42987 | 39249 | 35511 | 42987 | 39249 | 28384
 |  |  |  |  |  |  |  | 4100004388 |  |  |  |  |  |  | To close next termination contract |  |  |  | Missions | 00002 | 2024-01-09 00:00:00 | 2025-01-07 00:00:00 |  |  | 58014 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7255.81
 |  |  |  |  |  |  |  | 4100004388 | [PHONE] |  |  |  |  |  | To open |  | LE CHAUVE G | Phase 2 | Days | 00003 | 2024-01-09 00:00:00 | 2025-05-30 00:00:00 |  |  | 205590 | 1869 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40000 | 40000 | 40000 | 40000 | 40000
 |  |  |  |  |  |  |  | 4100004388 |  |  |  |  |  |  | To open |  |  |  | Missions | 00004 | 2024-01-09 00:00:00 | 2025-05-30 00:00:00 |  |  | 30838
 |  |  |  |  |  |  |  | 4100003513 | [PHONE] |  |  |  |  |  | Closed |  | BUISSON Z | Phase 1 | Days | 00001 | 2023-09-01 00:00:00 | 4/31/2023 |  |  | 89760 | 680 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7140 | 6800 | 7820 | 6460 | 6120 | 7480 | 7480
 |  |  |  |  |  |  |  | 4100003513 |  |  |  |  |  |  | Closed |  |  |  | Missions | 00002 | 2023-09-01 00:00:00 | 4/31/2023
 |  |  |  |  |  |  |  | 4100004072 | [PHONE] |  |  |  |  |  | Closed |  | [NAME] | Phase 1 | Days | 00001 | 2023-01-01 00:00:00 | 2023-12-31 00:00:00 |  |  | 77352 | 586 |  |  |  |  |  |  |  |  |  | 5860 | 5860 | 5860 | 5860 | 5860 | 5860 | 5860 | 5860 | 5860 | 5860 | 5860 | 5860
 |  |  |  |  |  |  |  | 4100004072 |  |  |  |  |  |  | Closed |  |  |  | Missions | 00002 | 2023-01-01 00:00:00 | 2023-12-31 00:00:00 |  |  | 7735
 |  |  |  |  |  |  |  | 4100003401 | [PHONE] |  |  |  |  |  | Closed |  | AL TATA MI M | Phase 2 | Days | 00003 | 2023-01-01 00:00:00 | 2023-12-31 00:00:00 |  |  | 225984 | 586
 |  |  |  |  |  |  |  | 4100003401 |  |  |  |  |  |  | Closed |  |  |  | Missions | 00004 | 2023-01-01 00:00:00 | 2023-12-31 00:00:00
 |  |  |  |  |  |  |  | 4100004715 | [PHONE] |  |  |  |  |  | Closed |  | AL TATAMI M | Phase 2 | Days | 00005 | 2024-01-01 00:00:00 | 2024-03-31 00:00:00 |  |  | 39040 | 610 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13420 | 12810 | 12810
 |  |  |  |  |  |  |  | 4100004715 |  |  |  |  |  |  | Closed |  |  |  | Missions | 00006 | 2024-01-01 00:00:00 | 2024-03-31 00:00:00
 |  |  |  |  |  |  |  | 4100004715 | [PHONE] |  |  |  |  |  | Closed |  | AL TATAMI M | Phase 2 | Days | 00007 | 2024-01-01 00:00:00 | 2024-03-31 00:00:00 |  |  | 39040 | 610 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13420 | 12810 | 12810
 |  |  |  |  |  |  |  | 4100004715 |  |  |  |  |  |  | Closed |  |  |  | Missions | 00008 | 2024-01-01 00:00:00 | 2024-03-31 00:00:00
 |  |  |  |  |  |  |  | 4100004095 | [PHONE] |  |  |  |  |  | Closed |  | VALENTO B | Phase 2 | Days | 00001 | 2022-10-03 00:00:00 | 2023-10-03 00:00:00 |  |  |  | 615 |  |  |  |  |  |  | 6909.53 | 6580.5 | 5264.4 | 6415.99 | 6580.5 | 7567.58 | 1316.1 | 1645.13 | 2632.2 | 2632.2 | 3290.25 | 2303.18
 |  |  |  |  |  |  |  | 4100004095 |  |  |  |  |  |  | Closed |  |  |  | Missions | 00002 | 2022-10-03 00:00:00 | 2023-10-03 00:00:00 |  |  | 13029
 |  |  |  |  |  |  |  | 4100004095 | [PHONE] |  |  |  |  |  | Closed |  | VALENTO B | Phase 2 | Days | 00003 | 2024-01-01 00:00:00 | 2024-10-03 00:00:00 |  |  | 121770 | 615 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14025.69 | 5842.5 |  |  |  | 12915 | 12915
 |  |  |  |  |  |  |  | 4100004095 |  |  |  |  |  |  | Closed |  |  |  | Missions | 00004 | 2024-01-01 00:00:00 | 2024-10-03 00:00:00 |  |  | 24354 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1268
 |  |  |  |  |  |  |  | 4100005382 | [PHONE] |  |  |  |  |  |  |  | VALENTO B | Phase 2 | Days | 00001 | 2024-10-04 00:00:00 | 2025-10-03 00:00:00 |  |  | 146454 | 634 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12000 | 9510 | 10778 | 19990.9375 | 19990.9375 | 19990.9375 | 19990.9375 | 19990.9375 | 19990.9375 | 19990.9375 | 19990.9375 | 19990.9375
 |  |  |  |  |  |  |  | 4100005382 |  |  |  |  |  |  |  |  |  |  | Missions | 00002 | 2024-10-04 00:00:00 | 2025-10-03 00:00:00 |  |  | 21968.1
 |  |  |  |  |  |  |  | 4100004104 | [PHONE] |  |  |  |  |  | Closed |  | DEGUIN P | Phase 2 | Days | 00001 | 2023-08-05 00:00:00 | 2024-05-10 00:00:00 |  |  | 146667 | 983.87 |  | 92027.43 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9630.81 | 22440.81 | 23355.81 | 22440.81 | 21525.81 | 23355.81 | 22440.81 |  | 22440.81
 |  |  |  |  |  |  |  | 4100003104 |  |  |  |  |  |  | Closed |  |  |  | Missions | 00002 | 2023-08-05 00:00:00 | 2024-05-10 00:00:00 |  |  | 22000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1960.38 | 1796.48
 |  |  |  |  |  |  |  | 4100004104 | [PHONE] |  |  |  |  |  | To close soon | 2024-11-01 00:00:00 | DNILOVIC M | Phase 2 | Days | 00003 | 2024-05-06 00:00:00 | 2024-07-27 00:00:00 |  |  |  | 946.23 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18780.81 |  | 24270.81
 |  |  |  |  |  |  |  | 4100004104 |  |  |  |  |  |  | To close soon | 2024-11-01 00:00:00 |  |  | Missions | 00004 |  |  |  |  | 30800
 |  |  |  |  |  |  |  | 4100004104 | [PHONE] |  |  |  |  |  | To close soon | 2024-11-01 00:00:00 | DNILOVIC M | Phase 2 | Days | 00005 | 2024-07-28 00:00:00 | 2024-12-31 00:00:00 |  |  | 176215.07 | 946.23 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24865.67 | 20134.52
 |  |  |  |  |  |  |  | 4100004104 |  |  |  |  |  |  | To close soon | 2024-11-01 00:00:00 |  |  | Missions | 00006 |  |  |  |  | 22709.41
 |  |  |  |  |  |  |  |  | [PHONE] |  |  |  |  |  | To open |  | SHATTERJEE E | Phase 2 | Days | 00001 | 2025-02-01 00:00:00 | 2026-02-02 00:00:00 |  |  | 218295 | 945 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22000 | 22000 | 22000 | 22000 | 22000 | 22000 | 22000 | 22000 | 22000 | 22000 | 22000 | 22000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | To open |  |  |  | Missions | 00002 |  |  |  |  | 32744
 |  |  |  |  |  |  |  | 4100003817 | [PHONE] |  |  |  |  |  | To close soon | 2024-12-01 00:00:00 | TURIOL PL | Phase 2 | Days | 00001 | 2023-01-01 00:00:00 | 2023-12-31 00:00:00 |  |  |  | 855 |  |  |  |  |  |  |  |  |  | 12720 | 14707.5 | 15105 | 15105 | 13515 | 17490 | 11130 | 7950 | 15105 | 17490 | 16595 | 12720
 |  |  |  |  |  |  |  | 4100003817 |  |  |  |  |  |  | To close soon | 2024-12-01 00:00:00 |  |  | Missions | 00002 |  |  |  |  | 22572
 |  |  |  |  |  |  |  | 4100003817 | [PHONE] |  |  |  |  |  | To close soon | 2024-12-01 00:00:00 | TURIOL PL | Phase 2 | Days | 00003 | 2024-01-01 00:00:00 | 2024-12-31 00:00:00 |  |  | 191730 | 830 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14940 | 13280 | 16185 | 14110 | 14525 | 15770 | 19090 | 5810 | 17430 | 13280 | 16600 |  | 16000
 |  |  |  |  |  |  |  | 4100003817 |  |  |  |  |  |  | To close soon | 2024-12-01 00:00:00 |  |  | Missions | 00004 |  |  |  |  | 28760 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 660.05
 |  |  |  |  |  |  |  |  | [PHONE] |  |  |  |  |  | To open |  | TURIOL PL | Phase 2 | Days | 00005 | 2025-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | To open |  |  |  | Missions | 00006
 |  |  |  |  |  |  |  | 4100004324 | [PHONE] |  |  |  |  |  | To close next termination contract |  | MONCHAL S | Phase 2 | Days | 00001 | 2024-01-01 00:00:00 | 2025-01-07 00:00:00 |  |  | 176946 | 766 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16086 | 15320 | 16086 | 16086 |  | 17618 | 13022 | 16086 | 17618 |  | 14554
 |  |  |  |  |  |  |  | 4100004324 |  |  |  |  |  |  | To close next termination contract |  |  |  | Missions | 00002 |  |  |  |  | 26541 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 326.61 | 464 | 755 | 248 | 68 | 268
 |  |  |  |  |  |  |  | 4100004324 | [PHONE] |  |  |  |  |  |  |  | MONCHAL S | Phase 2 | Days | 00003 | 2025-01-08 00:00:00 | 2025-05-30 00:00:00 |  |  | 176946 | 766 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16086 | 15703 | 15607.25 | 15870.5625
 |  |  |  |  |  |  |  | 4100004324 |  |  |  |  |  |  |  |  |  |  | Missions | 00004 |  |  |  |  | 26541