{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Feuil1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Feuil1","index":0,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[[6,3,6,4]]}
["Date Signature Accord","Durée Validité Accord\n(Mois / Ans)","Durée Validité Accord (Ans)","Date Expiration Accord"]
["2015-04-07","5 ans",{"$f":"IF(RIGHT(B2,4)=\" ans\",EDATE(A2,LEFT(B2,LEN(B2)-SEARCH(\" \",B2)-1)*12),EDATE(A2,LEFT(B2,LEN(B2)-SEARCH(\" \",B2)-1)))","v":"2020-04-07"},{"$f":"DATE(YEAR($A2)+$C2,MONTH($A2),DAY($A2))","v":{"$error":"#NUM!"}}]
["2019-07-15","15 mois",{"$f":"IF(RIGHT(B3,4)=\" ans\",EDATE(A3,LEFT(B3,LEN(B3)-SEARCH(\" \",B3)-1)*12),EDATE(A3,LEFT(B3,LEN(B3)-SEARCH(\" \",B3)-1)))","v":"2020-10-15"},{"$f":"DATE(YEAR($A3)+$C3,MONTH($A3),DAY($A3))","v":{"$error":"#NUM!"}}]
["2019-06-12","5 ans","2024-06-12",{"$error":"#NUM!"}]
["2014-05-23","2 ans","2016-05-23",{"$error":"#NUM!"}]
[null,null,"Si B= X ans,    C = X\nSi B = Y mois, C = Y/12"]