{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Feuil1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"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":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["2020-12-21","Date de départ",null,"Plage nommée \"Fériés\"",null,null,"Formule pour trouver le jour de congé",{"$f":"IF(MAX(IF((Fériés>=A1)*(Fériés<=A2)=1,Fériés))*1=0,\"\",MAX(IF((Fériés>=A1)*(Fériés<=A2)=1,Fériés)))","v":"2020-12-26"}]
[{"$f":"A1+6","v":"2020-12-27"},"Date de départ + 6",null,"2020-05-28",null,null,"entre les 2 dates en A1:A2"]
[null,null,null,"2020-05-29"]
[null,null,null,"2020-12-25",null,null,{"$f":"IFERROR(SMALL(IF((Fériés>=$A$1)*(Fériés<=$A$2)=1,Fériés),ROW(A1)),\"\")","v":"2020-12-25"},"Si tu as plus d'une date correspondant au critère"]
[null,null,null,"2020-12-26",null,null,{"$f":"IFERROR(SMALL(IF((Fériés>=$A$1)*(Fériés<=$A$2)=1,Fériés),ROW(A2)),\"\")","v":"2020-12-26"},"Tu tires la formule jusqu'au moment où rien ne s'affiche."]
[null,null,null,"2020-06-01"]
[null,null,null,"2020-06-02"]
[null,null,null,"2020-06-03"]
[null,null,null,"2020-06-04"]
[null,null,null,"2020-06-05"]