{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"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":"Sheet1","index":0,"n_rows":27,"n_cols":9,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Start","2020-06-01",null,null,null,null,null,{"$f":"ROUNDUP(0/7,0)","v":0}]
[null,"End","2020-06-30"]
[null,null,"数式"]
["StartからEnd","手法1","=DAYS(C3,C2)",{"$f":"_xlfn.DAYS(C3,C2)","v":29},"日","「開始日と終了日を指定し、その間の日数を求めます」"]
["までの日数"]
[null,"手法2","=DATEDIF(C2,C3,\"D\")",{"$f":"DATEDIF(C2,C3,\"D\")","v":29},"日","「開始日から終了日までの日数です」"]
[]
[null,"手法3","=C3-C2+1",{"$f":"C3-C2+1","v":30},"日","「終了日から開始日を引き、当日を含めるため１を足す」"]
[]
["平日の","手法4","=NETWORKDAYS(C2,C3)",{"$f":"NETWORKDAYS(C2,C3)","v":22},"日","「開始日と終了日を指定して、その期間内の稼動日の日数を返します。」"]
["日数"]
[null,"手法5","=NETWORKDAYS.INTL(C2,C3)",{"$f":"NETWORKDAYS.INTL(C2,C3)","v":22},"日","「週末の曜日を指示し、開始日と終了日の間にある稼働日の日数を返します。」"]
[]
[null,"手法6","=(C3+7-C2+1)-(ROUNDUP((C3+7-(C2+(6-IF(WEEKDAY(C2,2)=7,0,WEEKDAY(C2,2))))+1)/7,0))-(ROUNDUP((C3+7-(C2+(7-WEEKDAY(C2,2)))+1)/7,0))-5"]
[null,null,null,{"$f":"(C3+7-C2+1)-(ROUNDUP((C3+7-(C2+(6-IF(WEEKDAY(C2,2)=7,0,WEEKDAY(C2,2))))+1)/7,0))-(ROUNDUP((C3+7-(C2+(7-WEEKDAY(C2,2)))+1)/7,0))-5","v":22},"日","「全数から土曜と日曜の数を引く(月曜＝１)」"]
[]
[null,"手法7","=(C3+7-C2+1)-(ROUNDUP((C3+7-C2-(7-WEEKDAY(C2))+1)/7,0))-(ROUNDUP((C3+7-C2-(8-IF(WEEKDAY(C2)=1,8,WEEKDAY(C2)))+1)/7,0))-5"]
[null,null,null,{"$f":"(C3+7-C2+1)-(ROUNDUP((C3+7-C2-(7-WEEKDAY(C2))+1)/7,0))-(ROUNDUP((C3+7-C2-(8-IF(WEEKDAY(C2)=1,8,WEEKDAY(C2)))+1)/7,0))-5","v":22},"日","「全数から土曜と日曜の数を引く(日曜＝１)」"]
[]
[null,"手法8","=myWeekdays1(C2,C3)",{"$f":"myWeekdays1(C2,C3)","v":22},"日","「自作関数：WorksheetFunction（NETWORKDAYS　他）を使用」"]
[]
[null,"手法9","=myWeekdays2(C2,C3)",{"$f":"myWeekdays2(C2,C3)","v":22},"日","「自作関数：全対象日の曜日を調査」"]
[]
[null,"手法10","=myWeekdays3(C2,C3)",{"$f":"myWeekdays3(C2,C3)","v":22},"日","「自作関数：週数を計算し、その端数日数分のみ曜日を調査」"]
[]
[null,"手法11","=myWeekdays4(C2,C3)",{"$f":"myWeekdays4(C2,C3)","v":22},"日","「自作関数：対象範囲中央部の週数を計算し、その前後の端数があれば1ずつ足す」"]