{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["NBJOUR"],"read":"whole","date_system":"1900"}

{"sheet":"NBJOUR","index":0,"n_rows":20,"n_cols":13,"rows_kept":20,"merged":[[0,0,0,12],[1,1,1,12],[2,1,2,12],[4,2,4,4],[9,2,9,4],[10,2,10,4],[19,1,20,2]]}
[]
[null,"Calcul de la durée entre deux dates"]
[null,"selon l'année commerciale"]
[]
[null,null,"Dates",null,null,"correction",null,"année"]
[null,null,"jour","mois","année","j.","m.","bissextile",null,"calculs"]
[null,"Début :  ",15,11,1946,{"$f":"IF(D7=2,IF(H7=1,IF(C7=29,30,C7),IF(C7=28,30,C7)),IF(C7=31,30,C7))","v":15},{"$f":"D7","v":11},{"$f":"IF(E7/100=INT(E7/100),IF(E7/400=INT(E7/400),1,0),IF(E7/4=INT(E7/4),1,0))","v":0},{"$nulls":4},{"$f":"IF(H7=0,\"année normale\",\"année bissextile\")","v":"année normale"}]
[null,"Fin :  ",10,12,2008,{"$f":"IF(D8=2,IF(H8=1,IF(C8=29,30,C8),IF(C8=28,30,C8)),IF(C8=31,30,C8))","v":10},{"$f":"IF(E8-E7>0,D8+12,D8)","v":24},{"$f":"IF(E8/100=INT(E8/100),IF(E8/400=INT(E8/400),1,0),IF(E8/4=INT(E8/4),1,0))","v":1},null,"nb j.",{"$f":"30-F7+F8","v":25},null,{"$f":"IF(H8=0,\"année normale\",\"année bissextile\")","v":"année bissextile"}]
[{"$nulls":9},"nb m.",{"$f":"(G8-G7-1)*30","v":360}]
[null,"du",{"$f":"K16","v":"1946-11-15"},{"$nulls":6},"nb a.",{"$f":"IF(E8-E7>1,(E8-E7-1)*360,0)","v":21960}]
[null,"au",{"$f":"K17","v":"2008-12-10"},{"$nulls":6},"total :",{"$f":"SUM(K8:K10)","v":22345}]
[null,"il y a : "]
[null,"  année commerciale",{"$f":"K11","v":22345},"jours"]
[null,"  année window",{"$f":"DAYS360(K16,K17,TRUE)","v":22345},"\""]
[null,"  année US (NASD)",{"$f":"DAYS360(K16,K17,FALSE)","v":22345},"\""]
[null,"  année civile",{"$f":"K17-K16","v":22671},"\"",{"$nulls":4},"nb début",null,{"$f":"DATE(E7,D7,C7)","v":17121}]
[{"$nulls":8},"nb fin",null,{"$f":"DATE(E8,D8,C8)","v":39792}]
[]
[]
[null,"PS : Sont bissextiles les années divisibles par 4 mais non divisibles par 100 ou les années divisibles par 400"]