{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Feuil1","Feuil2","Feuil3"],"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":28,"n_cols":4,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Année",2016,"MOIS",1]
[]
[{"$f":"DATE(B1,D1,1)","v":"2016-01-01"},null,"la formule en A3 n'est pas la même que au dessous"]
[{"$f":"IF(A3=\"\",\"\",IF(MONTH(A3+IF(OR(WEEKDAY(A3,2)=1,WEEKDAY(A3,2)=6),3,1))<>MONTH(A3),\"\",IF(OR(WEEKDAY(A3,2)=1,WEEKDAY(A3,2)=6),A3+3,A3+1)))","v":"2016-01-02"},null,"le calendrier va jusqu'à la fin du mois automatiquement"]
[{"$f":"IF(A4=\"\",\"\",IF(MONTH(A4+IF(OR(WEEKDAY(A4,2)=1,WEEKDAY(A4,2)=6),3,1))<>MONTH(A4),\"\",IF(OR(WEEKDAY(A4,2)=1,WEEKDAY(A4,2)=6),A4+3,A4+1)))","v":"2016-01-05"},null,"le mois et l'année sont définis par B1 et D1"]
["2016-01-06",null,"on peut remplacer la formule en A3 par la date du premier jour (actif) du mois"]
["2016-01-07"]
["2016-01-08"]
["2016-01-09"]
["2016-01-12"]
["2016-01-13"]
["2016-01-14"]
["2016-01-15"]
["2016-01-16"]
["2016-01-19"]
["2016-01-20"]
["2016-01-21"]
["2016-01-22"]
["2016-01-23"]
["2016-01-26"]
["2016-01-27"]
["2016-01-28"]
["2016-01-29"]
["2016-01-30"]
[""]
[""]
[""]
[""]

{"sheet":"Feuil2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Feuil3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}