{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["使い方・使用許諾","原則・1か月変形"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":5,"comments":1,"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":"使い方・使用許諾","index":0,"n_rows":67,"n_cols":8,"rows_kept":67,"cut":false,"hidden":false,"merged":[[39,4,39,5],[39,6,39,7],[41,4,43,4],[47,4,49,4],[44,4,46,4],[41,6,41,7],[42,6,42,7],[44,6,44,7],[45,6,45,7]]}
["このツールについて"]
["・労働基準法上の「時間外労働」「休日労働」「深夜労働」の時間数を計算するツールです。"]
["・変形労働時間制を導入していない場合と1か月単位変形労働時間制に対応しています。"]
["・IFS関数やLET関数を使用しているため、バージョンの古いエクセルでは利用できない場合があります。"]
["・全ての勤怠状況において正しい時間計算を行うことを保証するものではありません。計算結果は自己責任でご利用ください。"]
[]
["使い方"]
["・計算条件と勤怠状況（勤務予定と勤務実績）を入力して「計算する」ボタンを押して下さい。"]
["・15行目が当月の初日です。A15セルに月の起算日を入力してください。"]
["・9～14行目は前月期間です。週が月をまたぐ場合に第1週目の週40時間超を計算したい場合に勤務実績を入力してください。"]
[]
["用語の説明"]
["番号","項目","説明"]
["①","所定労働時間","就業規則等で定めている1日の所定労働時間"]
["②","実働時間","実際に就労した時間（＝⑱法定内労働＋⑦時間外労働＋⑫法定休日労働）"]
["③","有給休暇時間","年次有給休暇や会社が定める有給の特別休暇を取得した時間（有給の不就労時間）"]
["④","法定休日労働時間","法定休日（0時～24時）の労働時間"]
["⑤","時間外労働時間（1日）","1日の法定労働時間を超える時間外労働時間"]
["⑥","時間外労働時間（週）","週の法定労働時間を超える時間外労働時間（⑤を除く）"]
["⑦","時間外労働時間（月）","月の法定労働時間を超える時間外労働時間（⑤⑥を除く）"]
["⑧","時間外労働時間（合計）","時間外労働時間（④～⑥の合計）"]
["⑨","時間外労働時間（60時間以下・勤務日）","⑦時間外労働のうち、月60時間以下で所定勤務日に行った時間"]
["⑩","時間外労働時間（60時間以下・所定休日）","⑦時間外労働のうち、月60時間以下で所定休日に行った時間"]
["⑪","時間外労働時間（60時間超・勤務日）","⑦時間外労働のうち、月60時間超で所定勤務日に行った時間"]
["⑫","時間外労働時間（60時間超・所定休日）","⑦時間外労働のうち、月60時間超で所定休日に行った時間"]
["⑬","深夜労働時間","深夜（22時～翌5時）の労働時間"]
["⑭","所定内労働時間","所定労働時間までの労働時間"]
["⑮","振替出勤","休日振替によって勤務した時間（⑦時間外労働と⑯所定外労働を除く）"]
["⑯","所定外労働時間","所定労働時間を超え法定労働時間までの労働時間（いわゆる法定内残業）"]
["⑰","所定休日労働時間","所定休日の労働時間（⑦時間外労働時間を除く）"]
["⑱","法定内労働時間（合計）","法定労働時間内の総労働時間（＝⑭所定内労働＋⑮振替出勤＋⑯所定外労働＋⑰所定休日労働）"]
["⑲","欠勤等時間","欠勤・遅刻・早退・無給の休暇などで通常賃金から控除する時間（無給の不就労時間）"]
["⑳","振替休日","振替休日（代休含む）の取得によって通常賃金から控除する時間"]
["㉑","100％賃金相殺時間","割増賃金の計算において100％部分を相殺して割増部分のみを支払う時間"]
["㉒","控除時間（合計）","控除時間の合計（＝⑲欠勤等時間＋⑳振替休日＋㉑100％賃金相殺時間）"]
["※⑭～㉒は有料版でのみ表示"]
[]
["その他"]
["・1か月単位変形労働時間制の月初や月末等で端数日がある週における週の法定労働時間は、「40（44）時間×端日数÷７」でみています。",null,null,null,"別表１　日をまたぐ勤務の時間計算"]
["・計算条件の「端数処理（切捨）」は、変形期間の法定労働時間を10進数で表示した場合の端数処理です。",null,null,null,"勤務区分",null,"計算方法"]
["（例）1か月単位変形労働時間制における変形期間（1か月間）の法定労働時間",null,null,null,"24時まで","24時以降","24時までの労働時間","24時以降の労働時間"]
["【端数処理なし】40時間×31日÷7＝177.14…時間（177:08）",null,null,null,"勤務日","勤務日","通算して所定内（外）労働又は時間外労働"]
["【第2位以下】 　40時間×31日÷7≒177.1時間（177:06）",null,null,null,null,"所定休日","通算して所定内（外）労働又は時間外労働"]
["【第1位以下】　 40時間×31日÷7≒177時間（177:00）",null,null,null,null,"法定休日","所定内（外）又は時間外","法定休日労働"]
["・一勤務が日をまたいだ場合の時間計算は別表１のとおり行っています。",null,null,null,"所定休日","勤務日","通算して所定休日労働又は時間外労働"]
["・下記の場合は、正しい時間計算を行えません。",null,null,null,null,"所定休日","通算して所定休日労働又は時間外労働"]
["(1)勤務終了が翌日の始業時刻を超える場合",null,null,null,null,"法定休日","所定休日労働又は時間外労働","法定休日労働"]
["(2)3交代勤務で休日を継続24時間としている場合",null,null,null,"法定休日","勤務日","法定休日労働","所定外労働又は時間外労働"]
["(3)その他、勤務状況が特殊である又は一般的とは言えない場合",null,null,null,null,"所定休日","法定休日労働","所定外労働又は時間外労働"]
[null,null,null,null,null,"法定休日","法定休日労働","法定休日労働"]
["使用許諾"]
["・当ツールの著作権及び知的所有権は、社会保険労務士事務所しのはら労働コンサルタントに帰属します。"]
["・当ツールの全部または一部の再配布、再使用許諾及び公開することを禁止します。"]
["・当ツールの利用により発生したトラブル・損失・損害については、一切責任を負いません。ご利用にあたっては自己責任でお願いします。"]
["・別料金にてカスタマイズを承ります。"]
[]
["作成・配付"]
["社会保険労務士事務所しのはら労働コンサルタント"]
["社会保険労務士　篠原宏治"]
["〒168-0062　東京都杉並区方南1-2-10-1F"]
["TEL","03-6300-4323"]
["FAX","03-6300-4324"]
["メール","mail@shlc.jp"]
[]
["元労働基準監督官による労務相談とエクセル業務効率化に強い社労士事務所です。"]
["労務相談、社会保険・労働保険手続き、給与計算のご依頼を随時受け付けております。"]
["お気軽にお問い合わせください。"]

{"sheet":"原則・1か月変形","index":1,"n_rows":47,"n_cols":28,"rows_kept":47,"cut":false,"hidden":false,"merged":[[6,1,6,4],[6,5,6,6],[6,7,6,8],[6,9,6,17],[6,19,6,22],[3,5,3,6],[3,8,3,10],[3,11,3,12],[3,14,3,16],[6,23,6,26],[1,5,1,6],[1,8,1,10],[1,11,1,12],[1,14,1,16],[2,5,2,6],[2,8,2,10],[2,11,2,12],[2,14,2,16],[1,19,2,20],[3,19,3,20],[4,19,4,20],[1,22,2,27],[3,22,4,27]]}
[null,null,null,null,null,"計算条件",null,null,null,null,null,null,null,null,null,null,null,null,"入力欄",null,null,"計算結果欄"]
[null,null,null,null,null,"週起算日",null,5,"1:日 2:月 3:火 4:水 5:木 6:金 7:土",null,null,"労働時間制",null,"原則","原則・1か月変形から選択",null,null,null,null,"入力可",null,null,"労基法第37条の割増賃金の対象となる時間"]
[null,null,null,null,null,"週締め日",null,{"$f":"IF(H2+6>7,H2-1,H2+6)","v":4},"週起算日から自動判定",null,null,"端数処理（切捨）",null,"第2位以下","月法定労働時間の端数処理"]
[null,null,null,null,null,"週法定労働時間",null,40,"40時間・44時間から選択",null,null,"月法定労働時間",null,{"$f":"IF(N2=\"原則\",0,ROUNDDOWN(COUNT(A15:A45)/7*H4,_xlfn.IFS(N3=\"なし\",99,N3=\"第1位以下\",0,N3=\"第2位以下\",1))/24)","v":0},"40（44）時間×暦日数÷7",null,null,null,null,"入力必須",null,null,"上記以外（給与や割増賃金の計算に使用する時間）"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"入力不可"]
["勤怠状況",null,null,null,null,null,{"$f":"IF(AND(N2 = \"1か月変形\",G46>N4),\"月の所定労働時間が週平均40(44)時間を超えています。\",\"\")","v":""}]
[null,"集計用",null,null,null,"勤務予定",null,"振替",null,"勤務実績",null,null,null,null,null,null,null,null,null,"時間外労働",null,null,null,"時間外労働内訳"]
["年月日","週\n締日","月\n締日","週\n日数","期間日数","休日","所定\n労働時間","振替","振替後の所定\n労働時間","始業時刻","終業時刻","休憩\n(0～5時)","休憩\n(5～22時)","休憩\n(22～24時)","休憩\n(24～翌5時)","休憩\n(翌5時～)","実働時間","有給休暇\n時間","法定休日","時間外(日)","時間外\n(週)","時間外\n(月)","時間外\n(合計)","勤務日\n(60H以下)","所定休日\n(60H以下)","勤務日\n(60H超)","所定休日\n(60H超)","深夜"]
[{"$f":"_xlfn.IFS($N$2=\"1か月変形\",\"-\",15-ROW(A9)<=WEEKDAY($A$15)-$H$2+IF(WEEKDAY($A$15)-$H$2<0,7,0),A10-1,TRUE,\"-\")","v":"-"},{"$f":"_xlfn.IFS(A9=\"-\",\"\",NOT(ISNUMBER(A10)),2,WEEKDAY(A9)=$H$3,1,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(A9=\"-\",\"\",$A$15=$A9,\"\",DAY($A$15)=DAY(A9+1),DATEDIF($A$15,A9+1,\"M\"),TRUE,\"\")","v":""},{"$f":"_xlfn.IFS($N$2=\"1か月変形\",\"\",A9=\"-\",\"\",ISTEXT(D8),1,ISTEXT(B8),D8+1,TRUE,1)","v":""},0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"K9-J9-SUM(L9:P9)","v":0}]
[{"$f":"_xlfn.IFS($N$2=\"1か月変形\",\"-\",15-ROW(A10)<=WEEKDAY($A$15)-$H$2+IF(WEEKDAY($A$15)-$H$2<0,7,0),A11-1,TRUE,\"-\")","v":"-"},{"$f":"_xlfn.IFS(A10=\"-\",\"\",NOT(ISNUMBER(A11)),2,WEEKDAY(A10)=$H$3,1,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(A10=\"-\",\"\",$A$15=$A10,\"\",DAY($A$15)=DAY(A10+1),DATEDIF($A$15,A10+1,\"M\"),TRUE,\"\")","v":""},{"$f":"_xlfn.IFS($N$2=\"1か月変形\",\"\",A10=\"-\",\"\",ISTEXT(D9),1,ISTEXT(B9),D9+1,TRUE,1)","v":""},0,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"_xlfn.IFS($N$2=\"1か月変形\",\"-\",15-ROW(A11)<=WEEKDAY($A$15)-$H$2+IF(WEEKDAY($A$15)-$H$2<0,7,0),A12-1,TRUE,\"-\")","v":"2023-12-28"},{"$f":"_xlfn.IFS(A11=\"-\",\"\",NOT(ISNUMBER(A12)),2,WEEKDAY(A11)=$H$3,1,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(A11=\"-\",\"\",$A$15=$A11,\"\",DAY($A$15)=DAY(A11+1),DATEDIF($A$15,A11+1,\"M\"),TRUE,\"\")","v":""},{"$f":"_xlfn.IFS($N$2=\"1か月変形\",\"\",A11=\"-\",\"\",ISTEXT(D10),1,ISTEXT(B10),D10+1,TRUE,1)","v":1},0,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"_xlfn.IFS($N$2=\"1か月変形\",\"-\",15-ROW(A12)<=WEEKDAY($A$15)-$H$2+IF(WEEKDAY($A$15)-$H$2<0,7,0),A13-1,TRUE,\"-\")","v":"2023-12-29"},{"$f":"_xlfn.IFS(A12=\"-\",\"\",NOT(ISNUMBER(A13)),2,WEEKDAY(A12)=$H$3,1,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(A12=\"-\",\"\",$A$15=$A12,\"\",DAY($A$15)=DAY(A12+1),DATEDIF($A$15,A12+1,\"M\"),TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(A12=\"-\",\"\",ISTEXT(D11),1,ISTEXT(B11),D11+1,TRUE,1)","v":2},0,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"_xlfn.IFS($N$2=\"1か月変形\",\"-\",15-ROW(A13)<=WEEKDAY($A$15)-$H$2+IF(WEEKDAY($A$15)-$H$2<0,7,0),A14-1,TRUE,\"-\")","v":"2023-12-30"},{"$f":"_xlfn.IFS(A13=\"-\",\"\",NOT(ISNUMBER(A14)),2,WEEKDAY(A13)=$H$3,1,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(A13=\"-\",\"\",$A$15=$A13,\"\",DAY($A$15)=DAY(A13+1),DATEDIF($A$15,A13+1,\"M\"),TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(A13=\"-\",\"\",ISTEXT(D12),1,ISTEXT(B12),D12+1,TRUE,1)","v":3},0,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"_xlfn.IFS($N$2=\"1か月変形\",\"-\",15-ROW(A14)<=WEEKDAY($A$15)-$H$2+IF(WEEKDAY($A$15)-$H$2<0,7,0),A15-1,TRUE,\"-\")","v":"2023-12-31"},{"$f":"_xlfn.IFS(A14=\"-\",\"\",NOT(ISNUMBER(A15)),2,WEEKDAY(A14)=$H$3,1,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(A14=\"-\",\"\",$A$15=$A14,\"\",DAY($A$15)=DAY(A14+1),DATEDIF($A$15,A14+1,\"M\"),TRUE,\"\")","v":0},{"$f":"_xlfn.IFS(A14=\"-\",\"\",ISTEXT(D13),1,ISTEXT(B13),D13+1,TRUE,1)","v":4},0,null,null,null,null,null,null,null,null,null,null,null,0]
["2024-01-01",{"$f":"_xlfn.IFS(A15=\"-\",\"\",NOT(ISNUMBER(A16)),2,WEEKDAY(A15)=$H$3,1,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(A15=\"-\",\"\",$A$15=$A15,\"\",DAY($A$15)=DAY(A15+1),DATEDIF($A$15,A15+1,\"M\"),TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AND(ROW(A15)=15,N2=\"1か月変形\"),1,A15=\"-\",\"\",ISTEXT(D14),1,ISTEXT(B14),D14+1,TRUE,1)","v":5},{"$f":"_xlfn.IFS(A15=\"-\",\"\",ISTEXT(E14),1,TRUE,E14+1)","v":1},null,null,null,null,null,null,null,null,null,null,null,{"$f":"K15-J15-SUM(L15:P15)","v":0}]
[{"$f":"_xlfn.IFS(A15= \"-\",\"-\",DAY($A$15)=DAY(A15+1),\"-\",TRUE,A15+1)","v":"2024-01-02"},{"$f":"_xlfn.IFS(A16=\"-\",\"\",NOT(ISNUMBER(A17)),2,WEEKDAY(A16)=$H$3,1,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(A16=\"-\",\"\",$A$15=$A16,\"\",DAY($A$15)=DAY(A16+1),DATEDIF($A$15,A16+1,\"M\"),TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AND(ROW(A16)=15,N3=\"1か月変形\"),1,A16=\"-\",\"\",ISTEXT(D15),1,ISTEXT(B15),D15+1,TRUE,1)","v":6},{"$f":"_xlfn.IFS(A16=\"-\",\"\",ISTEXT(E15),1,TRUE,E15+1)","v":2},null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"_xlfn.IFS(A16= \"-\",\"-\",DAY($A$15)=DAY(A16+1),\"-\",TRUE,A16+1)","v":"2024-01-03"},{"$f":"_xlfn.IFS(A17=\"-\",\"\",NOT(ISNUMBER(A18)),2,WEEKDAY(A17)=$H$3,1,TRUE,\"\")","v":1},{"$f":"_xlfn.IFS(A17=\"-\",\"\",$A$15=$A17,\"\",DAY($A$15)=DAY(A17+1),DATEDIF($A$15,A17+1,\"M\"),TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AND(ROW(A17)=15,N4=\"1か月変形\"),1,A17=\"-\",\"\",ISTEXT(D16),1,ISTEXT(B16),D16+1,TRUE,1)","v":7},{"$f":"_xlfn.IFS(A17=\"-\",\"\",ISTEXT(E16),1,TRUE,E16+1)","v":3},null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"_xlfn.IFS(A17= \"-\",\"-\",DAY($A$15)=DAY(A17+1),\"-\",TRUE,A17+1)","v":"2024-01-04"},{"$f":"_xlfn.IFS(A18=\"-\",\"\",NOT(ISNUMBER(A19)),2,WEEKDAY(A18)=$H$3,1,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(A18=\"-\",\"\",$A$15=$A18,\"\",DAY($A$15)=DAY(A18+1),DATEDIF($A$15,A18+1,\"M\"),TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AND(ROW(A18)=15,N5=\"1か月変形\"),1,A18=\"-\",\"\",ISTEXT(D17),1,ISTEXT(B17),D17+1,TRUE,1)","v":1},{"$f":"_xlfn.IFS(A18=\"-\",\"\",ISTEXT(E17),1,TRUE,E17+1)","v":4},null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"_xlfn.IFS(A18= \"-\",\"-\",DAY($A$15)=DAY(A18+1),\"-\",TRUE,A18+1)","v":"2024-01-05"},{"$f":"_xlfn.IFS(A19=\"-\",\"\",NOT(ISNUMBER(A20)),2,WEEKDAY(A19)=$H$3,1,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(A19=\"-\",\"\",$A$15=$A19,\"\",DAY($A$15)=DAY(A19+1),DATEDIF($A$15,A19+1,\"M\"),TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AND(ROW(A19)=15,N6=\"1か月変形\"),1,A19=\"-\",\"\",ISTEXT(D18),1,ISTEXT(B18),D18+1,TRUE,1)","v":2},{"$f":"_xlfn.IFS(A19=\"-\",\"\",ISTEXT(E18),1,TRUE,E18+1)","v":5},null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"_xlfn.IFS(A19= \"-\",\"-\",DAY($A$15)=DAY(A19+1),\"-\",TRUE,A19+1)","v":"2024-01-06"},{"$f":"_xlfn.IFS(A20=\"-\",\"\",NOT(ISNUMBER(A21)),2,WEEKDAY(A20)=$H$3,1,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(A20=\"-\",\"\",$A$15=$A20,\"\",DAY($A$15)=DAY(A20+1),DATEDIF($A$15,A20+1,\"M\"),TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AND(ROW(A20)=15,N7=\"1か月変形\"),1,A20=\"-\",\"\",ISTEXT(D19),1,ISTEXT(B19),D19+1,TRUE,1)","v":3},{"$f":"_xlfn.IFS(A20=\"-\",\"\",ISTEXT(E19),1,TRUE,E19+1)","v":6},null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"_xlfn.IFS(A20= \"-\",\"-\",DAY($A$15)=DAY(A20+1),\"-\",TRUE,A20+1)","v":"2024-01-07"},{"$f":"_xlfn.IFS(A21=\"-\",\"\",NOT(ISNUMBER(A22)),2,WEEKDAY(A21)=$H$3,1,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(A21=\"-\",\"\",$A$15=$A21,\"\",DAY($A$15)=DAY(A21+1),DATEDIF($A$15,A21+1,\"M\"),TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AND(ROW(A21)=15,N8=\"1か月変形\"),1,A21=\"-\",\"\",ISTEXT(D20),1,ISTEXT(B20),D20+1,TRUE,1)","v":4},{"$f":"_xlfn.IFS(A21=\"-\",\"\",ISTEXT(E20),1,TRUE,E20+1)","v":7},null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"_xlfn.IFS(A21= \"-\",\"-\",DAY($A$15)=DAY(A21+1),\"-\",TRUE,A21+1)","v":"2024-01-08"},{"$f":"_xlfn.IFS(A22=\"-\",\"\",NOT(ISNUMBER(A23)),2,WEEKDAY(A22)=$H$3,1,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(A22=\"-\",\"\",$A$15=$A22,\"\",DAY($A$15)=DAY(A22+1),DATEDIF($A$15,A22+1,\"M\"),TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AND(ROW(A22)=15,N9=\"1か月変形\"),1,A22=\"-\",\"\",ISTEXT(D21),1,ISTEXT(B21),D21+1,TRUE,1)","v":5},{"$f":"_xlfn.IFS(A22=\"-\",\"\",ISTEXT(E21),1,TRUE,E21+1)","v":8},null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"_xlfn.IFS(A22= \"-\",\"-\",DAY($A$15)=DAY(A22+1),\"-\",TRUE,A22+1)","v":"2024-01-09"},{"$f":"_xlfn.IFS(A23=\"-\",\"\",NOT(ISNUMBER(A24)),2,WEEKDAY(A23)=$H$3,1,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(A23=\"-\",\"\",$A$15=$A23,\"\",DAY($A$15)=DAY(A23+1),DATEDIF($A$15,A23+1,\"M\"),TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AND(ROW(A23)=15,N10=\"1か月変形\"),1,A23=\"-\",\"\",ISTEXT(D22),1,ISTEXT(B22),D22+1,TRUE,1)","v":6},{"$f":"_xlfn.IFS(A23=\"-\",\"\",ISTEXT(E22),1,TRUE,E22+1)","v":9},null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"_xlfn.IFS(A23= \"-\",\"-\",DAY($A$15)=DAY(A23+1),\"-\",TRUE,A23+1)","v":"2024-01-10"},{"$f":"_xlfn.IFS(A24=\"-\",\"\",NOT(ISNUMBER(A25)),2,WEEKDAY(A24)=$H$3,1,TRUE,\"\")","v":1},{"$f":"_xlfn.IFS(A24=\"-\",\"\",$A$15=$A24,\"\",DAY($A$15)=DAY(A24+1),DATEDIF($A$15,A24+1,\"M\"),TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AND(ROW(A24)=15,N11=\"1か月変形\"),1,A24=\"-\",\"\",ISTEXT(D23),1,ISTEXT(B23),D23+1,TRUE,1)","v":7},{"$f":"_xlfn.IFS(A24=\"-\",\"\",ISTEXT(E23),1,TRUE,E23+1)","v":10},null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"_xlfn.IFS(A24= \"-\",\"-\",DAY($A$15)=DAY(A24+1),\"-\",TRUE,A24+1)","v":"2024-01-11"},{"$f":"_xlfn.IFS(A25=\"-\",\"\",NOT(ISNUMBER(A26)),2,WEEKDAY(A25)=$H$3,1,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(A25=\"-\",\"\",$A$15=$A25,\"\",DAY($A$15)=DAY(A25+1),DATEDIF($A$15,A25+1,\"M\"),TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AND(ROW(A25)=15,N12=\"1か月変形\"),1,A25=\"-\",\"\",ISTEXT(D24),1,ISTEXT(B24),D24+1,TRUE,1)","v":1},{"$f":"_xlfn.IFS(A25=\"-\",\"\",ISTEXT(E24),1,TRUE,E24+1)","v":11},null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"_xlfn.IFS(A25= \"-\",\"-\",DAY($A$15)=DAY(A25+1),\"-\",TRUE,A25+1)","v":"2024-01-12"},{"$f":"_xlfn.IFS(A26=\"-\",\"\",NOT(ISNUMBER(A27)),2,WEEKDAY(A26)=$H$3,1,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(A26=\"-\",\"\",$A$15=$A26,\"\",DAY($A$15)=DAY(A26+1),DATEDIF($A$15,A26+1,\"M\"),TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AND(ROW(A26)=15,N13=\"1か月変形\"),1,A26=\"-\",\"\",ISTEXT(D25),1,ISTEXT(B25),D25+1,TRUE,1)","v":2},{"$f":"_xlfn.IFS(A26=\"-\",\"\",ISTEXT(E25),1,TRUE,E25+1)","v":12},null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"_xlfn.IFS(A26= \"-\",\"-\",DAY($A$15)=DAY(A26+1),\"-\",TRUE,A26+1)","v":"2024-01-13"},{"$f":"_xlfn.IFS(A27=\"-\",\"\",NOT(ISNUMBER(A28)),2,WEEKDAY(A27)=$H$3,1,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(A27=\"-\",\"\",$A$15=$A27,\"\",DAY($A$15)=DAY(A27+1),DATEDIF($A$15,A27+1,\"M\"),TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AND(ROW(A27)=15,N14=\"1か月変形\"),1,A27=\"-\",\"\",ISTEXT(D26),1,ISTEXT(B26),D26+1,TRUE,1)","v":3},{"$f":"_xlfn.IFS(A27=\"-\",\"\",ISTEXT(E26),1,TRUE,E26+1)","v":13},null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"_xlfn.IFS(A27= \"-\",\"-\",DAY($A$15)=DAY(A27+1),\"-\",TRUE,A27+1)","v":"2024-01-14"},{"$f":"_xlfn.IFS(A28=\"-\",\"\",NOT(ISNUMBER(A29)),2,WEEKDAY(A28)=$H$3,1,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(A28=\"-\",\"\",$A$15=$A28,\"\",DAY($A$15)=DAY(A28+1),DATEDIF($A$15,A28+1,\"M\"),TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AND(ROW(A28)=15,N15=\"1か月変形\"),1,A28=\"-\",\"\",ISTEXT(D27),1,ISTEXT(B27),D27+1,TRUE,1)","v":4},{"$f":"_xlfn.IFS(A28=\"-\",\"\",ISTEXT(E27),1,TRUE,E27+1)","v":14},null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"_xlfn.IFS(A28= \"-\",\"-\",DAY($A$15)=DAY(A28+1),\"-\",TRUE,A28+1)","v":"2024-01-15"},{"$f":"_xlfn.IFS(A29=\"-\",\"\",NOT(ISNUMBER(A30)),2,WEEKDAY(A29)=$H$3,1,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(A29=\"-\",\"\",$A$15=$A29,\"\",DAY($A$15)=DAY(A29+1),DATEDIF($A$15,A29+1,\"M\"),TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AND(ROW(A29)=15,N16=\"1か月変形\"),1,A29=\"-\",\"\",ISTEXT(D28),1,ISTEXT(B28),D28+1,TRUE,1)","v":5},{"$f":"_xlfn.IFS(A29=\"-\",\"\",ISTEXT(E28),1,TRUE,E28+1)","v":15},null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"_xlfn.IFS(A29= \"-\",\"-\",DAY($A$15)=DAY(A29+1),\"-\",TRUE,A29+1)","v":"2024-01-16"},{"$f":"_xlfn.IFS(A30=\"-\",\"\",NOT(ISNUMBER(A31)),2,WEEKDAY(A30)=$H$3,1,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(A30=\"-\",\"\",$A$15=$A30,\"\",DAY($A$15)=DAY(A30+1),DATEDIF($A$15,A30+1,\"M\"),TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AND(ROW(A30)=15,N17=\"1か月変形\"),1,A30=\"-\",\"\",ISTEXT(D29),1,ISTEXT(B29),D29+1,TRUE,1)","v":6},{"$f":"_xlfn.IFS(A30=\"-\",\"\",ISTEXT(E29),1,TRUE,E29+1)","v":16},null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"_xlfn.IFS(A30= \"-\",\"-\",DAY($A$15)=DAY(A30+1),\"-\",TRUE,A30+1)","v":"2024-01-17"},{"$f":"_xlfn.IFS(A31=\"-\",\"\",NOT(ISNUMBER(A32)),2,WEEKDAY(A31)=$H$3,1,TRUE,\"\")","v":1},{"$f":"_xlfn.IFS(A31=\"-\",\"\",$A$15=$A31,\"\",DAY($A$15)=DAY(A31+1),DATEDIF($A$15,A31+1,\"M\"),TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AND(ROW(A31)=15,N18=\"1か月変形\"),1,A31=\"-\",\"\",ISTEXT(D30),1,ISTEXT(B30),D30+1,TRUE,1)","v":7},{"$f":"_xlfn.IFS(A31=\"-\",\"\",ISTEXT(E30),1,TRUE,E30+1)","v":17},null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"_xlfn.IFS(A31= \"-\",\"-\",DAY($A$15)=DAY(A31+1),\"-\",TRUE,A31+1)","v":"2024-01-18"},{"$f":"_xlfn.IFS(A32=\"-\",\"\",NOT(ISNUMBER(A33)),2,WEEKDAY(A32)=$H$3,1,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(A32=\"-\",\"\",$A$15=$A32,\"\",DAY($A$15)=DAY(A32+1),DATEDIF($A$15,A32+1,\"M\"),TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AND(ROW(A32)=15,N19=\"1か月変形\"),1,A32=\"-\",\"\",ISTEXT(D31),1,ISTEXT(B31),D31+1,TRUE,1)","v":1},{"$f":"_xlfn.IFS(A32=\"-\",\"\",ISTEXT(E31),1,TRUE,E31+1)","v":18},null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"_xlfn.IFS(A32= \"-\",\"-\",DAY($A$15)=DAY(A32+1),\"-\",TRUE,A32+1)","v":"2024-01-19"},{"$f":"_xlfn.IFS(A33=\"-\",\"\",NOT(ISNUMBER(A34)),2,WEEKDAY(A33)=$H$3,1,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(A33=\"-\",\"\",$A$15=$A33,\"\",DAY($A$15)=DAY(A33+1),DATEDIF($A$15,A33+1,\"M\"),TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AND(ROW(A33)=15,N20=\"1か月変形\"),1,A33=\"-\",\"\",ISTEXT(D32),1,ISTEXT(B32),D32+1,TRUE,1)","v":2},{"$f":"_xlfn.IFS(A33=\"-\",\"\",ISTEXT(E32),1,TRUE,E32+1)","v":19},null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"_xlfn.IFS(A33= \"-\",\"-\",DAY($A$15)=DAY(A33+1),\"-\",TRUE,A33+1)","v":"2024-01-20"},{"$f":"_xlfn.IFS(A34=\"-\",\"\",NOT(ISNUMBER(A35)),2,WEEKDAY(A34)=$H$3,1,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(A34=\"-\",\"\",$A$15=$A34,\"\",DAY($A$15)=DAY(A34+1),DATEDIF($A$15,A34+1,\"M\"),TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AND(ROW(A34)=15,N21=\"1か月変形\"),1,A34=\"-\",\"\",ISTEXT(D33),1,ISTEXT(B33),D33+1,TRUE,1)","v":3},{"$f":"_xlfn.IFS(A34=\"-\",\"\",ISTEXT(E33),1,TRUE,E33+1)","v":20},null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"_xlfn.IFS(A34= \"-\",\"-\",DAY($A$15)=DAY(A34+1),\"-\",TRUE,A34+1)","v":"2024-01-21"},{"$f":"_xlfn.IFS(A35=\"-\",\"\",NOT(ISNUMBER(A36)),2,WEEKDAY(A35)=$H$3,1,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(A35=\"-\",\"\",$A$15=$A35,\"\",DAY($A$15)=DAY(A35+1),DATEDIF($A$15,A35+1,\"M\"),TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AND(ROW(A35)=15,N22=\"1か月変形\"),1,A35=\"-\",\"\",ISTEXT(D34),1,ISTEXT(B34),D34+1,TRUE,1)","v":4},{"$f":"_xlfn.IFS(A35=\"-\",\"\",ISTEXT(E34),1,TRUE,E34+1)","v":21},null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"_xlfn.IFS(A35= \"-\",\"-\",DAY($A$15)=DAY(A35+1),\"-\",TRUE,A35+1)","v":"2024-01-22"},{"$f":"_xlfn.IFS(A36=\"-\",\"\",NOT(ISNUMBER(A37)),2,WEEKDAY(A36)=$H$3,1,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(A36=\"-\",\"\",$A$15=$A36,\"\",DAY($A$15)=DAY(A36+1),DATEDIF($A$15,A36+1,\"M\"),TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AND(ROW(A36)=15,N23=\"1か月変形\"),1,A36=\"-\",\"\",ISTEXT(D35),1,ISTEXT(B35),D35+1,TRUE,1)","v":5},{"$f":"_xlfn.IFS(A36=\"-\",\"\",ISTEXT(E35),1,TRUE,E35+1)","v":22},null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"_xlfn.IFS(A36= \"-\",\"-\",DAY($A$15)=DAY(A36+1),\"-\",TRUE,A36+1)","v":"2024-01-23"},{"$f":"_xlfn.IFS(A37=\"-\",\"\",NOT(ISNUMBER(A38)),2,WEEKDAY(A37)=$H$3,1,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(A37=\"-\",\"\",$A$15=$A37,\"\",DAY($A$15)=DAY(A37+1),DATEDIF($A$15,A37+1,\"M\"),TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AND(ROW(A37)=15,N24=\"1か月変形\"),1,A37=\"-\",\"\",ISTEXT(D36),1,ISTEXT(B36),D36+1,TRUE,1)","v":6},{"$f":"_xlfn.IFS(A37=\"-\",\"\",ISTEXT(E36),1,TRUE,E36+1)","v":23},null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"_xlfn.IFS(A37= \"-\",\"-\",DAY($A$15)=DAY(A37+1),\"-\",TRUE,A37+1)","v":"2024-01-24"},{"$f":"_xlfn.IFS(A38=\"-\",\"\",NOT(ISNUMBER(A39)),2,WEEKDAY(A38)=$H$3,1,TRUE,\"\")","v":1},{"$f":"_xlfn.IFS(A38=\"-\",\"\",$A$15=$A38,\"\",DAY($A$15)=DAY(A38+1),DATEDIF($A$15,A38+1,\"M\"),TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AND(ROW(A38)=15,N25=\"1か月変形\"),1,A38=\"-\",\"\",ISTEXT(D37),1,ISTEXT(B37),D37+1,TRUE,1)","v":7},{"$f":"_xlfn.IFS(A38=\"-\",\"\",ISTEXT(E37),1,TRUE,E37+1)","v":24},null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"_xlfn.IFS(A38= \"-\",\"-\",DAY($A$15)=DAY(A38+1),\"-\",TRUE,A38+1)","v":"2024-01-25"},{"$f":"_xlfn.IFS(A39=\"-\",\"\",NOT(ISNUMBER(A40)),2,WEEKDAY(A39)=$H$3,1,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(A39=\"-\",\"\",$A$15=$A39,\"\",DAY($A$15)=DAY(A39+1),DATEDIF($A$15,A39+1,\"M\"),TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AND(ROW(A39)=15,N26=\"1か月変形\"),1,A39=\"-\",\"\",ISTEXT(D38),1,ISTEXT(B38),D38+1,TRUE,1)","v":1},{"$f":"_xlfn.IFS(A39=\"-\",\"\",ISTEXT(E38),1,TRUE,E38+1)","v":25},null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"_xlfn.IFS(A39= \"-\",\"-\",DAY($A$15)=DAY(A39+1),\"-\",TRUE,A39+1)","v":"2024-01-26"},{"$f":"_xlfn.IFS(A40=\"-\",\"\",NOT(ISNUMBER(A41)),2,WEEKDAY(A40)=$H$3,1,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(A40=\"-\",\"\",$A$15=$A40,\"\",DAY($A$15)=DAY(A40+1),DATEDIF($A$15,A40+1,\"M\"),TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AND(ROW(A40)=15,N27=\"1か月変形\"),1,A40=\"-\",\"\",ISTEXT(D39),1,ISTEXT(B39),D39+1,TRUE,1)","v":2},{"$f":"_xlfn.IFS(A40=\"-\",\"\",ISTEXT(E39),1,TRUE,E39+1)","v":26},null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"_xlfn.IFS(A40= \"-\",\"-\",DAY($A$15)=DAY(A40+1),\"-\",TRUE,A40+1)","v":"2024-01-27"},{"$f":"_xlfn.IFS(A41=\"-\",\"\",NOT(ISNUMBER(A42)),2,WEEKDAY(A41)=$H$3,1,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(A41=\"-\",\"\",$A$15=$A41,\"\",DAY($A$15)=DAY(A41+1),DATEDIF($A$15,A41+1,\"M\"),TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AND(ROW(A41)=15,N28=\"1か月変形\"),1,A41=\"-\",\"\",ISTEXT(D40),1,ISTEXT(B40),D40+1,TRUE,1)","v":3},{"$f":"_xlfn.IFS(A41=\"-\",\"\",ISTEXT(E40),1,TRUE,E40+1)","v":27},null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"_xlfn.IFS(A41= \"-\",\"-\",DAY($A$15)=DAY(A41+1),\"-\",TRUE,A41+1)","v":"2024-01-28"},{"$f":"_xlfn.IFS(A42=\"-\",\"\",NOT(ISNUMBER(A43)),2,WEEKDAY(A42)=$H$3,1,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(A42=\"-\",\"\",$A$15=$A42,\"\",DAY($A$15)=DAY(A42+1),DATEDIF($A$15,A42+1,\"M\"),TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AND(ROW(A42)=15,N29=\"1か月変形\"),1,A42=\"-\",\"\",ISTEXT(D41),1,ISTEXT(B41),D41+1,TRUE,1)","v":4},{"$f":"_xlfn.IFS(A42=\"-\",\"\",ISTEXT(E41),1,TRUE,E41+1)","v":28},null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"_xlfn.IFS(A42= \"-\",\"-\",DAY($A$15)=DAY(A42+1),\"-\",TRUE,A42+1)","v":"2024-01-29"},{"$f":"_xlfn.IFS(A43=\"-\",\"\",NOT(ISNUMBER(A44)),2,WEEKDAY(A43)=$H$3,1,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(A43=\"-\",\"\",$A$15=$A43,\"\",DAY($A$15)=DAY(A43+1),DATEDIF($A$15,A43+1,\"M\"),TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AND(ROW(A43)=15,N30=\"1か月変形\"),1,A43=\"-\",\"\",ISTEXT(D42),1,ISTEXT(B42),D42+1,TRUE,1)","v":5},{"$f":"_xlfn.IFS(A43=\"-\",\"\",ISTEXT(E42),1,TRUE,E42+1)","v":29},null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"_xlfn.IFS(A43= \"-\",\"-\",DAY($A$15)=DAY(A43+1),\"-\",TRUE,A43+1)","v":"2024-01-30"},{"$f":"_xlfn.IFS(A44=\"-\",\"\",NOT(ISNUMBER(A45)),2,WEEKDAY(A44)=$H$3,1,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(A44=\"-\",\"\",$A$15=$A44,\"\",DAY($A$15)=DAY(A44+1),DATEDIF($A$15,A44+1,\"M\"),TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AND(ROW(A44)=15,N31=\"1か月変形\"),1,A44=\"-\",\"\",ISTEXT(D43),1,ISTEXT(B43),D43+1,TRUE,1)","v":6},{"$f":"_xlfn.IFS(A44=\"-\",\"\",ISTEXT(E43),1,TRUE,E43+1)","v":30},null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"_xlfn.IFS(A44= \"-\",\"-\",DAY($A$15)=DAY(A44+1),\"-\",TRUE,A44+1)","v":"2024-01-31"},{"$f":"_xlfn.IFS(A45=\"-\",\"\",NOT(ISNUMBER(A46)),2,WEEKDAY(A45)=$H$3,1,TRUE,\"\")","v":2},{"$f":"_xlfn.IFS(A45=\"-\",\"\",$A$15=$A45,\"\",DAY($A$15)=DAY(A45+1),DATEDIF($A$15,A45+1,\"M\"),TRUE,\"\")","v":1},{"$f":"_xlfn.IFS(AND(ROW(A45)=15,N32=\"1か月変形\"),1,A45=\"-\",\"\",ISTEXT(D44),1,ISTEXT(B44),D44+1,TRUE,1)","v":7},{"$f":"_xlfn.IFS(A45=\"-\",\"\",ISTEXT(E44),1,TRUE,E44+1)","v":31},null,null,null,null,null,null,null,null,null,null,null,0]
["合計",null,null,null,null,null,{"$f":"SUM(G15:G45)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q15:Q45)","v":0},{"$f":"SUM(R15:R45)","v":0},{"$f":"SUM(S15:S45)","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,"①",null,null,null,null,null,null,null,null,null,"②","③","④","⑤","⑥","⑦","⑧","⑨","⑩","⑪","⑫","⑬"]