{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["計算書","計算書入力例(新規)","計算書入力例 (再取得)","設定","設定 (2)","設定 (3)"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"comments":3,"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":42,"n_cols":27,"rows_kept":42,"cut":false,"hidden":false,"merged":[[40,0,40,2],[32,6,32,13],[19,6,19,13],[33,6,33,13],[16,21,16,22],[27,6,27,13],[18,6,18,13],[18,17,18,18],[24,17,24,18],[32,17,32,18],[34,16,34,17],[40,15,40,16],[17,21,17,22],[18,21,18,22],[19,21,19,22],[20,16,20,17],[1,0,2,18],[10,21,10,22],[11,21,11,22],[7,16,7,17],[2,21,2,22],[4,21,4,22],[3,21,3,22],[9,21,9,22],[10,17,10,18],[41,15,41,16],[28,16,28,17],[15,21,15,22],[6,21,6,22],[13,6,13,13],[14,16,14,17],[6,6,6,13]]}
[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,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,"番号"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"氏名"]
["１","標準報酬日額    標準報酬月額×1/22"]
[null,null,null,{"$f":"IF(V16=\"\",V10,V16)","v":0},"円",null,"×1/22",null,null,null,null,null,null,null,"=",null,{"$f":"IF(D7=\"\",\"\",ROUND(D7*1/22,-1))","v":0},"円","（A）",null,"出産日",null,null,null,{"$f":"IF(V7=\"\",\"\",(DATE(MID(V7,2,2)+2018,MID(V7,4,2),RIGHT(V7,2))))","v":""},{"$f":"IF(V7=\"\",\"\",EDATE(Y7,18))","v":""},{"$f":"IF(V7=\"\",\"\",INT(5&0&(YEAR(Z7)-2018)&IF(MONTH(Z7)<10,0&MONTH(Z7),MONTH(Z7))&IF(DAY(Z7)<10,0&DAY(Z7),DAY(Z7))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"（10円未満四捨五入）"]
[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,null,null,null,null,null,null,null,null,null,"標準報酬月額"]
[null,"①育児休業をした期間が180日に達するまで    ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((IF(V19=\"\",Y11,Y19))<設定!C3,IF(Q14<Q19,Q14,Q19),\"\")","v":""},{"$f":"IF(Q11=\"\",\"\",\"←(R\"&YEAR(設定!C3-1)-2018&\".\"&MONTH(設定!C3-1)&\".\"&DAY(設定!C3-1)&\"まで)\")","v":""},null,null,"育児休業開始日",null,null,null,{"$f":"IF(V11=\"\",\"\",(DATE(MID(V11,2,2)+2018,MID(V11,4,2),RIGHT(V11,2))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q7=\"\",\"\",IF(Q14<Q20,Q14,Q20))","v":0},"円","（B）※",null,"請求の末日",null,null,null,{"$f":"IF(V12=\"\",\"\",(DATE(MID(V12,2,2)+2018,MID(V12,4,2),RIGHT(V12,2))))","v":""}]
[null,null,"標準報酬日額（A）×給付率 67/100"]
[null,null,null,{"$f":"IF(Q7=\"\",\"\",Q7)","v":0},"円",null,"×67/100",null,null,null,null,null,null,null,"=",null,{"$f":"ROUNDDOWN(D14*67/100,0)","v":0},"円","（B1）",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,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,null,{"$f":"IF(V17=\"\",\"\",(DATE(MID(V17,2,2)+2018,MID(V17,4,2),RIGHT(V17,2))))","v":""}]
[null,null,"規定により変更された場合には、当該変更された後の額）×30×67/100×1/22",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"当初請求の末日",null,null,null,{"$f":"IF(V18=\"\",\"\",(DATE(MID(V18,2,2)+2018,MID(V18,4,2),RIGHT(V18,2))))","v":""}]
[null,null,null,{"$f":"IF((IF(Y19=\"\",Y11,Y19))<設定!C3,IF(Y17=\"\",IF(Y11=\"\",\"\",IF(Y11<設定!C2,\"\",設定!E2)),IF(Y17<設定!C2,\"\",設定!E2)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((IF(Y19=\"\",Y11,Y19))<設定!C3,ROUNDDOWN(D19*30*67/100*1/22,0),\"\")","v":""},{"$f":"IF(Q19=\"\",\"\",\"←(R\"&YEAR(設定!C3-1)-2018&\".\"&MONTH(設定!C3-1)&\".\"&DAY(設定!C3-1)&\"まで)\")","v":""},null,null,"再取得育児休業開始日",null,null,null,{"$f":"IF(V19=\"\",\"\",(DATE(MID(V19,2,2)+2018,MID(V19,4,2),RIGHT(V19,2))))","v":""}]
[null,null,null,{"$f":"設定!E3","v":15690},"円",null,"×30×67/100×1/22",null,null,null,null,null,null,null,"=",null,{"$f":"IF(D20=\"\",\"\",ROUNDDOWN(D20*30*67/100*1/22,0))","v":14334},"円","（B2）",null,"再取得に係る請求の末日",null,null,null,{"$f":"IF(V20=\"\",\"\",(DATE(MID(V20,2,2)+2018,MID(V20,4,2),RIGHT(V20,2))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"（円未満切捨て）"]
[null,"  ※B1＜B2の場合・・・B=B1"]
[null,"    B1≧B2の場合・・・B=B2"]
[]
[null,"②育児休業をした期間が通算180日経過後",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((IF(Y19=\"\",Y11,Y19))<設定!C3,IF(Q28<Q33,Q28,Q33),\"\")","v":""},{"$f":"IF(Q25=\"\",\"\",\"←(R\"&YEAR(設定!C3-1)-2018&\".\"&MONTH(設定!C3-1)&\".\"&DAY(設定!C3-1)&\"まで)\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D7=\"\",\"\",IF(Q28<Q34,Q28,Q34))","v":0},"円","（C）※"]
[null,null,"標準報酬日額（A）×給付率 50/100"]
[null,null,null,{"$f":"IF(Q7=\"\",\"\",Q7)","v":0},"円",null,"×50/100",null,null,null,null,null,null,null,"=",null,{"$f":"ROUNDDOWN(D28*1*50/100,0)","v":0},"円","（C1）"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"（円未満切捨て）"]
[null,"  給付上限相当額"]
[null,null,"雇用保険法第１７条第４項第２号ハに定める額に相当する額（当該額が同法第１８条の"]
[null,null,"規定により変更された場合には、当該変更された後の額）×30×50/100×1/22"]
[null,null,null,{"$f":"IF((IF(Y19=\"\",Y11,Y19))<設定!C3,IF(Y17=\"\",IF(Y11=\"\",\"\",IF(Y11<設定!C2,\"\",設定!E2)),IF(Y17<設定!C2,\"\",設定!E2)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((IF(Y19=\"\",Y11,Y19))<設定!C3,ROUNDDOWN(D33*30*50/100*1/22,0),\"\")","v":""},{"$f":"IF(Q33=\"\",\"\",\"←(R\"&YEAR(設定!C3-1)-2018&\".\"&MONTH(設定!C3-1)&\".\"&DAY(設定!C3-1)&\"まで)\")","v":""}]
[null,null,null,{"$f":"設定!E3","v":15690},"円",null,"×30×50/100×1/22",null,null,null,null,null,null,null,"=",null,{"$f":"IF(D34=\"\",\"\",ROUNDDOWN(D34*30*50/100*1/22,0))","v":10697},"円","（C2）"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"（円未満切捨て）"]
[null,"  ※C1＜C2の場合・・・C=C1"]
[null,"    C1≧C2の場合・・・C=C2"]
[]
["３  育児休業手当金支給額"]
[null,null,"（B）×給付率67/100の支給日数＋（C）×給付率50/100の支給日数"]
[{"$f":"IF(D41=\"\",\"\",\"(R\"&YEAR(設定!C3-1)-2018&\".\"&MONTH(設定!C3-1)&\".\"&DAY(設定!C3-1)&\"まで)→\")","v":""},null,null,{"$f":"IF((IF(Y19=\"\",Y11,Y19))<設定!C3,Q11,\"\")","v":""},null,null,{"$f":"IF((IF(Y19=\"\",Y11,Y19))<設定!C3,IF(V16=\"\",設定!G12,設定!G22),\"\")","v":""},null,null,{"$f":"IF((IF(Y19=\"\",Y11,Y19))<設定!C3,Q25,\"\")","v":""},null,null,{"$f":"IF((IF(Y19=\"\",Y11,Y19))<設定!C3,IF(V16=\"\",設定!G13,設定!G23),\"\")","v":""}]
[null,null,null,{"$f":"Q12","v":0},"円","×",{"$f":"IF(V16=\"\",設定!J12,設定!J22)","v":0},"日","＋",{"$f":"Q26","v":0},"円","×",{"$f":"IF(V16=\"\",設定!J13,設定!J23)","v":0},"日","=",{"$f":"IF(D41=\"\",0,D41*G41+J41*M41)+(D42*G42+J42*M42)","v":0},null,"円"]

{"sheet":"計算書入力例(新規)","index":1,"n_rows":42,"n_cols":27,"rows_kept":42,"cut":false,"hidden":false,"merged":[[41,15,41,16],[32,6,32,13],[32,17,32,18],[33,6,33,13],[34,16,34,17],[40,0,40,2],[40,15,40,16],[19,6,19,13],[19,21,19,22],[20,16,20,17],[24,17,24,18],[27,6,27,13],[28,16,28,17],[14,16,14,17],[15,21,15,22],[16,21,16,22],[17,21,17,22],[18,6,18,13],[18,17,18,18],[18,21,18,22],[13,6,13,13],[1,0,2,18],[2,21,2,22],[3,21,3,22],[4,21,4,22],[6,6,6,13],[6,21,6,22],[7,16,7,17],[9,21,9,22],[10,17,10,18],[10,21,10,22],[11,21,11,22]]}
[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,null,null,null,null,null,null,null,null,null,null,"記号",999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"番号",9999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"氏名","共済　太郎"]
["１","標準報酬日額    標準報酬月額×1/22"]
[null,null,null,{"$f":"IF(V16=\"\",V10,V16)","v":320000},"円",null,"×1/22",null,null,null,null,null,null,null,"=",null,{"$f":"IF(D7=\"\",\"\",ROUND(D7*1/22,-1))","v":14550},"円","（A）",null,"出産日",5061226,null,null,{"$f":"IF(V7=\"\",\"\",(DATE(MID(V7,2,2)+2018,MID(V7,4,2),RIGHT(V7,2))))","v":"2024-12-26"},{"$f":"IF(V7=\"\",\"\",EDATE(Y7,18))","v":"2026-06-26"},{"$f":"IF(V7=\"\",\"\",INT(5&0&(YEAR(Z7)-2018)&IF(MONTH(Z7)<10,0&MONTH(Z7),MONTH(Z7))&IF(DAY(Z7)<10,0&DAY(Z7),DAY(Z7))))","v":5080626}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"（10円未満四捨五入）"]
[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,null,null,null,null,null,null,null,null,null,"標準報酬月額",320000]
[null,"①育児休業をした期間が180日に達するまで    ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((IF(V19=\"\",Y11,Y19))<設定!C3,IF(Q14<Q19,Q14,Q19),\"\")","v":""},{"$f":"IF(Q11=\"\",\"\",\"←(R\"&YEAR(設定!C3-1)-2018&\".\"&MONTH(設定!C3-1)&\".\"&DAY(設定!C3-1)&\"まで)\")","v":""},null,null,"育児休業開始日",5070221,null,null,{"$f":"IF(V11=\"\",\"\",(DATE(MID(V11,2,2)+2018,MID(V11,4,2),RIGHT(V11,2))))","v":"2025-02-21"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q7=\"\",\"\",IF(Q14<Q20,Q14,Q20))","v":9748},"円","（B）※",null,"請求の末日",5071225,null,null,{"$f":"IF(V12=\"\",\"\",(DATE(MID(V12,2,2)+2018,MID(V12,4,2),RIGHT(V12,2))))","v":"2025-12-25"}]
[null,null,"標準報酬日額（A）×給付率 67/100"]
[null,null,null,{"$f":"IF(Q7=\"\",\"\",Q7)","v":14550},"円",null,"×67/100",null,null,null,null,null,null,null,"=",null,{"$f":"ROUNDDOWN(D14*67/100,0)","v":9748},"円","（B1）",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,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,null,{"$f":"IF(V17=\"\",\"\",(DATE(MID(V17,2,2)+2018,MID(V17,4,2),RIGHT(V17,2))))","v":""}]
[null,null,"規定により変更された場合には、当該変更された後の額）×30×67/100×1/22",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"当初請求の末日",null,null,null,{"$f":"IF(V18=\"\",\"\",(DATE(MID(V18,2,2)+2018,MID(V18,4,2),RIGHT(V18,2))))","v":""}]
[null,null,null,{"$f":"IF((IF(Y19=\"\",Y11,Y19))<設定!C3,IF(Y17=\"\",IF(Y11=\"\",\"\",IF(Y11<設定!C2,\"\",設定!E2)),IF(Y17<設定!C2,\"\",設定!E2)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((IF(Y19=\"\",Y11,Y19))<設定!C3,ROUNDDOWN(D19*30*67/100*1/22,0),\"\")","v":""},{"$f":"IF(Q19=\"\",\"\",\"←(R\"&YEAR(設定!C3-1)-2018&\".\"&MONTH(設定!C3-1)&\".\"&DAY(設定!C3-1)&\"まで)\")","v":""},null,null,"再取得育児休業開始日",null,null,null,{"$f":"IF(V19=\"\",\"\",(DATE(MID(V19,2,2)+2018,MID(V19,4,2),RIGHT(V19,2))))","v":""}]
[null,null,null,{"$f":"設定!E3","v":15690},"円",null,"×30×67/100×1/22",null,null,null,null,null,null,null,"=",null,{"$f":"IF(D20=\"\",\"\",ROUNDDOWN(D20*30*67/100*1/22,0))","v":14334},"円","（B2）",null,"再取得に係る請求の末日",null,null,null,{"$f":"IF(V20=\"\",\"\",(DATE(MID(V20,2,2)+2018,MID(V20,4,2),RIGHT(V20,2))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"（円未満切捨て）"]
[null,"  ※B1＜B2の場合・・・B=B1"]
[null,"    B1≧B2の場合・・・B=B2"]
[]
[null,"②育児休業をした期間が通算180日経過後",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((IF(Y19=\"\",Y11,Y19))<設定!C3,IF(Q28<Q33,Q28,Q33),\"\")","v":""},{"$f":"IF(Q25=\"\",\"\",\"←(R\"&YEAR(設定!C3-1)-2018&\".\"&MONTH(設定!C3-1)&\".\"&DAY(設定!C3-1)&\"まで)\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D7=\"\",\"\",IF(Q28<Q34,Q28,Q34))","v":7275},"円","（C）※"]
[null,null,"標準報酬日額（A）×給付率 50/100"]
[null,null,null,{"$f":"IF(Q7=\"\",\"\",Q7)","v":14550},"円",null,"×50/100",null,null,null,null,null,null,null,"=",null,{"$f":"ROUNDDOWN(D28*1*50/100,0)","v":7275},"円","（C1）"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"（円未満切捨て）"]
[null,"  給付上限相当額"]
[null,null,"雇用保険法第１７条第４項第２号ハに定める額に相当する額（当該額が同法第１８条の"]
[null,null,"規定により変更された場合には、当該変更された後の額）×30×50/100×1/22"]
[null,null,null,{"$f":"IF((IF(Y19=\"\",Y11,Y19))<設定!C3,IF(Y17=\"\",IF(Y11=\"\",\"\",IF(Y11<設定!C2,\"\",設定!E2)),IF(Y17<設定!C2,\"\",設定!E2)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((IF(Y19=\"\",Y11,Y19))<設定!C3,ROUNDDOWN(D33*30*50/100*1/22,0),\"\")","v":""},{"$f":"IF(Q33=\"\",\"\",\"←(R\"&YEAR(設定!C3-1)-2018&\".\"&MONTH(設定!C3-1)&\".\"&DAY(設定!C3-1)&\"まで)\")","v":""}]
[null,null,null,{"$f":"設定!E3","v":15690},"円",null,"×30×50/100×1/22",null,null,null,null,null,null,null,"=",null,{"$f":"IF(D34=\"\",\"\",ROUNDDOWN(D34*30*50/100*1/22,0))","v":10697},"円","（C2）"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"（円未満切捨て）"]
[null,"  ※C1＜C2の場合・・・C=C1"]
[null,"    C1≧C2の場合・・・C=C2"]
[]
["３  育児休業手当金支給額"]
[null,null,"（B）×給付率67/100の支給日数＋（C）×給付率50/100の支給日数"]
[{"$f":"IF(D41=\"\",\"\",\"(R\"&YEAR(設定!C3-1)-2018&\".\"&MONTH(設定!C3-1)&\".\"&DAY(設定!C3-1)&\"まで)→\")","v":""},null,null,{"$f":"IF((IF(Y19=\"\",Y11,Y19))<設定!C3,Q11,\"\")","v":""},null,null,{"$f":"IF((IF(Y19=\"\",Y11,Y19))<'設定 (2)'!C3,IF(V16=\"\",'設定 (2)'!G12,'設定 (2)'!G22),\"\")","v":""},null,null,{"$f":"IF((IF(Y19=\"\",Y11,Y19))<設定!C3,Q25,\"\")","v":""},null,null,{"$f":"IF((IF(Y19=\"\",Y11,Y19))<'設定 (2)'!C3,IF(V16=\"\",'設定 (2)'!G13,'設定 (2)'!G23),\"\")","v":""}]
[null,null,null,{"$f":"Q12","v":9748},"円","×",{"$f":"IF(V16=\"\",'設定 (2)'!J12,'設定 (2)'!J22)","v":128},"日","＋",{"$f":"Q26","v":7275},"円","×",{"$f":"IF(V16=\"\",'設定 (2)'!J13,'設定 (2)'!J23)","v":92},"日","=",{"$f":"IF(D41=\"\",0,D41*G41+J41*M41)+(D42*G42+J42*M42)","v":1917044},null,"円"]

{"sheet":"計算書入力例 (再取得)","index":2,"n_rows":42,"n_cols":27,"rows_kept":42,"cut":false,"hidden":false,"merged":[[41,15,41,16],[32,6,32,13],[32,17,32,18],[33,6,33,13],[34,16,34,17],[40,0,40,2],[40,15,40,16],[19,6,19,13],[19,21,19,22],[20,16,20,17],[24,17,24,18],[27,6,27,13],[28,16,28,17],[14,16,14,17],[15,21,15,22],[16,21,16,22],[17,21,17,22],[18,6,18,13],[18,17,18,18],[18,21,18,22],[13,6,13,13],[1,0,2,18],[2,21,2,22],[3,21,3,22],[4,21,4,22],[6,6,6,13],[6,21,6,22],[7,16,7,17],[9,21,9,22],[10,17,10,18],[10,21,10,22],[11,21,11,22]]}
[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,null,null,null,null,null,null,null,null,null,null,"記号",999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"番号",9999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"氏名","共済　太郎"]
["１","標準報酬日額    標準報酬月額×1/22"]
[null,null,null,{"$f":"IF(V16=\"\",V10,V16)","v":280000},"円",null,"×1/22",null,null,null,null,null,null,null,"=",null,{"$f":"IF(D7=\"\",\"\",ROUND(D7*1/22,-1))","v":12730},"円","（A）",null,"出産日",5060528,null,null,{"$f":"IF(V7=\"\",\"\",(DATE(MID(V7,2,2)+2018,MID(V7,4,2),RIGHT(V7,2))))","v":"2024-05-28"},{"$f":"IF(V7=\"\",\"\",EDATE(Y7,18))","v":"2025-11-28"},{"$f":"IF(V7=\"\",\"\",INT(5&0&(YEAR(Z7)-2018)&IF(MONTH(Z7)<10,0&MONTH(Z7),MONTH(Z7))&IF(DAY(Z7)<10,0&DAY(Z7),DAY(Z7))))","v":5071128}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"（10円未満四捨五入）"]
[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,null,null,null,null,null,null,null,null,null,"標準報酬月額"]
[null,"①育児休業をした期間が180日に達するまで    ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((IF(V19=\"\",Y11,Y19))<設定!C3,IF(Q14<Q19,Q14,Q19),\"\")","v":""},{"$f":"IF(Q11=\"\",\"\",\"←(R\"&YEAR(設定!C3-1)-2018&\".\"&MONTH(設定!C3-1)&\".\"&DAY(設定!C3-1)&\"まで)\")","v":""},null,null,"育児休業開始日",null,null,null,{"$f":"IF(V11=\"\",\"\",(DATE(MID(V11,2,2)+2018,MID(V11,4,2),RIGHT(V11,2))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q7=\"\",\"\",IF(Q14<Q20,Q14,Q20))","v":8529},"円","（B）※",null,"請求の末日",null,null,null,{"$f":"IF(V12=\"\",\"\",(DATE(MID(V12,2,2)+2018,MID(V12,4,2),RIGHT(V12,2))))","v":""}]
[null,null,"標準報酬日額（A）×給付率 67/100"]
[null,null,null,{"$f":"IF(Q7=\"\",\"\",Q7)","v":12730},"円",null,"×67/100",null,null,null,null,null,null,null,"=",null,{"$f":"ROUNDDOWN(D14*67/100,0)","v":8529},"円","（B1）",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,null,null,null,null,null,null,null,null,null,"標準報酬月額",280000]
[null,null,"雇用保険法第１７条第４項第２号ハに定める額に相当する額（当該額が同法第１８条の",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"当初育児休業開始日",5060627,null,null,{"$f":"IF(V17=\"\",\"\",(DATE(MID(V17,2,2)+2018,MID(V17,4,2),RIGHT(V17,2))))","v":"2024-06-27"}]
[null,null,"規定により変更された場合には、当該変更された後の額）×30×67/100×1/22",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"当初請求の末日",5061220,null,null,{"$f":"IF(V18=\"\",\"\",(DATE(MID(V18,2,2)+2018,MID(V18,4,2),RIGHT(V18,2))))","v":"2024-12-20"}]
[null,null,null,{"$f":"IF((IF(Y19=\"\",Y11,Y19))<設定!C3,IF(Y17=\"\",IF(Y11=\"\",\"\",IF(Y11<設定!C2,\"\",設定!E2)),IF(Y17<設定!C2,\"\",設定!E2)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((IF(Y19=\"\",Y11,Y19))<設定!C3,ROUNDDOWN(D19*30*67/100*1/22,0),\"\")","v":""},{"$f":"IF(Q19=\"\",\"\",\"←(R\"&YEAR(設定!C3-1)-2018&\".\"&MONTH(設定!C3-1)&\".\"&DAY(設定!C3-1)&\"まで)\")","v":""},null,null,"再取得育児休業開始日",5070204,null,null,{"$f":"IF(V19=\"\",\"\",(DATE(MID(V19,2,2)+2018,MID(V19,4,2),RIGHT(V19,2))))","v":"2025-02-04"}]
[null,null,null,{"$f":"設定!E3","v":15690},"円",null,"×30×67/100×1/22",null,null,null,null,null,null,null,"=",null,{"$f":"IF(D20=\"\",\"\",ROUNDDOWN(D20*30*67/100*1/22,0))","v":14334},"円","（B2）",null,"再取得に係る請求の末日",5070527,null,null,{"$f":"IF(V20=\"\",\"\",(DATE(MID(V20,2,2)+2018,MID(V20,4,2),RIGHT(V20,2))))","v":"2025-05-27"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"（円未満切捨て）"]
[null,"  ※B1＜B2の場合・・・B=B1"]
[null,"    B1≧B2の場合・・・B=B2"]
[]
[null,"②育児休業をした期間が通算180日経過後",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((IF(Y19=\"\",Y11,Y19))<設定!C3,IF(Q28<Q33,Q28,Q33),\"\")","v":""},{"$f":"IF(Q25=\"\",\"\",\"←(R\"&YEAR(設定!C3-1)-2018&\".\"&MONTH(設定!C3-1)&\".\"&DAY(設定!C3-1)&\"まで)\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D7=\"\",\"\",IF(Q28<Q34,Q28,Q34))","v":6365},"円","（C）※"]
[null,null,"標準報酬日額（A）×給付率 50/100"]
[null,null,null,{"$f":"IF(Q7=\"\",\"\",Q7)","v":12730},"円",null,"×50/100",null,null,null,null,null,null,null,"=",null,{"$f":"ROUNDDOWN(D28*1*50/100,0)","v":6365},"円","（C1）"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"（円未満切捨て）"]
[null,"  給付上限相当額"]
[null,null,"雇用保険法第１７条第４項第２号ハに定める額に相当する額（当該額が同法第１８条の"]
[null,null,"規定により変更された場合には、当該変更された後の額）×30×50/100×1/22"]
[null,null,null,{"$f":"IF((IF(Y19=\"\",Y11,Y19))<設定!C3,IF(Y17=\"\",IF(Y11=\"\",\"\",IF(Y11<設定!C2,\"\",設定!E2)),IF(Y17<設定!C2,\"\",設定!E2)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((IF(Y19=\"\",Y11,Y19))<設定!C3,ROUNDDOWN(D33*30*50/100*1/22,0),\"\")","v":""},{"$f":"IF(Q33=\"\",\"\",\"←(R\"&YEAR(設定!C3-1)-2018&\".\"&MONTH(設定!C3-1)&\".\"&DAY(設定!C3-1)&\"まで)\")","v":""}]
[null,null,null,{"$f":"設定!E3","v":15690},"円",null,"×30×50/100×1/22",null,null,null,null,null,null,null,"=",null,{"$f":"IF(D34=\"\",\"\",ROUNDDOWN(D34*30*50/100*1/22,0))","v":10697},"円","（C2）"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"（円未満切捨て）"]
[null,"  ※C1＜C2の場合・・・C=C1"]
[null,"    C1≧C2の場合・・・C=C2"]
[]
["３  育児休業手当金支給額"]
[null,null,"（B）×給付率67/100の支給日数＋（C）×給付率50/100の支給日数"]
[{"$f":"IF(D41=\"\",\"\",\"(R\"&YEAR(設定!C3-1)-2018&\".\"&MONTH(設定!C3-1)&\".\"&DAY(設定!C3-1)&\"まで)→\")","v":""},null,null,{"$f":"IF((IF(Y19=\"\",Y11,Y19))<'設定 (3)'!C3,Q11,\"\")","v":""},null,null,{"$f":"IF((IF(Y19=\"\",Y11,Y19))<'設定 (3)'!C3,IF(V16=\"\",'設定 (3)'!G12,'設定 (3)'!G22),\"\")","v":""},null,null,{"$f":"IF((IF(Y19=\"\",Y11,Y19))<'設定 (3)'!C3,Q25,\"\")","v":""},null,null,{"$f":"IF((IF(Y19=\"\",Y11,Y19))<'設定 (3)'!C3,IF(V16=\"\",'設定 (3)'!G13,'設定 (3)'!G23),\"\")","v":""}]
[null,null,null,{"$f":"Q12","v":8529},"円","×",{"$f":"IF(V16=\"\",'設定 (3)'!J12,'設定 (3)'!J22)","v":3},"日","＋",{"$f":"Q26","v":6365},"円","×",{"$f":"IF(V16=\"\",'設定 (3)'!J13,'設定 (3)'!J23)","v":78},"日","=",{"$f":"IF(D41=\"\",0,D41*G41+J41*M41)+(D42*G42+J42*M42)","v":522057},null,"円"]

{"sheet":"設定","index":3,"n_rows":23,"n_cols":11,"rows_kept":23,"cut":false,"hidden":true,"merged":[[1,0,2,1]]}
[]
["雇用保険法第１８条第１項及び第２項により自動変更される額",null,"2023-08-01","適用",15430,"円","①"]
[null,null,"2024-08-01","適用",15690,"円","②"]
[]
["育児休業"]
[null,"開始日",{"$f":"IF(計算書!V16=\"\",計算書!Y11,計算書!Y17)","v":""}]
[null,"終了日",{"$f":"IF(計算書!V16=\"\",計算書!Y12,計算書!Y18)","v":""}]
[null,"180日到達日",{"$f":"IF(OR(C6=\"\",C7=\"\"),\"\",IF((C7-C6+1)<180,\"180日未満\",C6+179))","v":""}]
[]
["日数等"]
[null,"育児休業期間",{"$f":"IF(OR(C6=\"\",C7=\"\"),0,C7-C6+1)","v":0},"日"]
[null,"給付率67/100日数",{"$f":"IF(OR(C6=\"\",C7=\"\"),0,IF(C8=\"180日未満\",NETWORKDAYS(C6,C7),NETWORKDAYS(C6,C8)))","v":0},"日",null,"①",{"$f":"IF(OR(C6=\"\",C7=\"\"),0,IF(C8=\"180日未満\",IF(C7<C3,NETWORKDAYS(C6,C7),IF(C6<C3,NETWORKDAYS(C6,C3-1),0)),IF(C7<C3,NETWORKDAYS(C6,C3-1),IF(C6<C3,IF(C8<C3,NETWORKDAYS(C6,C8),NETWORKDAYS(C6,C3-1)),0))))","v":0},"日","②",{"$f":"IF(OR(C6=\"\",C7=\"\"),0,IF(C8=\"180日未満\",IF(C7<C3,0,IF(C6<C3,NETWORKDAYS(C3,C7),NETWORKDAYS(C6,C7))),IF(C7<C3,0,IF(C6<C3,IF(C8<C3,0,NETWORKDAYS(C3,C8)),NETWORKDAYS(C6,C8)))))","v":0},"日"]
[null,"給付率50/100日数",{"$f":"IF(OR(C6=\"\",C7=\"\"),0,IF(OR(C8=\"180日未満\",C7=C6+179),0,NETWORKDAYS(C8+1,C7)))","v":0},"日",null,"①",{"$f":"IF(OR(C6=\"\",C7=\"\"),0,IF(OR(C8=\"180日未満\",C7=C6+179),0,IF(C7<C3,NETWORKDAYS(C8+1,C7),IF(C6<C3,IF(C8<C3,NETWORKDAYS(C8+1,C3-1),0),0))))","v":0},"日","②",{"$f":"IF(OR(C6=\"\",C7=\"\"),0,IF(OR(C8=\"180日未満\",C7=C6+179),0,IF(C7<C3,0,IF(C6<C3,IF(C8<C3,NETWORKDAYS(C3,C7),NETWORKDAYS(C8+1,C7)),NETWORKDAYS(C8+1,C7)))))","v":0},"日"]
[]
["再取得"]
[null,"開始日",{"$f":"IF(計算書!V16=\"\",\"\",計算書!Y19)","v":""}]
[null,"終了日",{"$f":"IF(計算書!V16=\"\",\"\",計算書!Y20)","v":""}]
[null,"180日到達日",{"$f":"IF(計算書!V16=\"\",\"\",IF(OR(C8=\"\",C8=\"180日未満\"),IF(((C7-C6+1)+(C17-C16+1))<180,\"180日未満\",C16+179-(C7-C6+1)),\"×\"))","v":""}]
[]
["再取得日数等"]
[null,"育児休業期間",{"$f":"IF(OR(C16=\"\",C17=\"\"),0,C17-C16+1)","v":0},"日"]
[null,"給付率67/100日数",{"$f":"IF(OR(計算書!V16=\"\",C18=\"×\"),0,IF(C18=\"180日未満\",NETWORKDAYS(C16,C17),NETWORKDAYS(C16,C18)))","v":0},"日",null,"①",{"$f":"IF(OR(計算書!V16=\"\",C18=\"×\"),0,IF(C18=\"180日未満\",IF(C17<C3,NETWORKDAYS(C16,C17),IF(C16<C3,NETWORKDAYS(C16,C3-1),0)),IF(C17<C3,NETWORKDAYS(C16,C18),IF(C16<C3,IF(C18<C3,NETWORKDAYS(C16,C18),NETWORKDAYS(C16,C3-1)),0))))","v":0},"日","②",{"$f":"IF(OR(計算書!V16=\"\",C18=\"×\"),0,IF(C18=\"180日未満\",IF(C17<C3,0,IF(C16<C3,NETWORKDAYS(C3,C17),NETWORKDAYS(C16,C17))),IF(C17<C3,0,IF(C16<C3,IF(C18<C3,0,NETWORKDAYS(C3,C18)),NETWORKDAYS(C16,C18)))))","v":0},"日"]
[null,"給付率50/100日数",{"$f":"IF(計算書!V16=\"\",0,IF(C18=\"180日未満\",0,IF(C18=\"×\",NETWORKDAYS(C16,C17),NETWORKDAYS(C18+1,C17))))","v":0},"日",null,"①",{"$f":"IF(計算書!V16=\"\",0,IF(C18=\"180日未満\",0,IF(C18=\"×\",IF(C17<C3,NETWORKDAYS(C16,C17),IF(C16<C3,NETWORKDAYS(C16,C3-1),0)),IF(C17<C3,NETWORKDAYS(C18+1,C17),IF(C16<C3,IF(C18<C3,NETWORKDAYS(C18+1,C3-1),0),0)))))","v":0},"日","②",{"$f":"IF(計算書!V16=\"\",0,IF(C18=\"180日未満\",0,IF(C18=\"×\",IF(C17<C3,0,IF(C16<C3,NETWORKDAYS(C3,C17),NETWORKDAYS(C16,C17))),IF(C17<C3,0,IF(C18<C3,IF(C18<C3,NETWORKDAYS(C3,C17),NETWORKDAYS(C18+1,C17)),NETWORKDAYS(C18+1,C17))))))","v":0},"日"]

{"sheet":"設定 (2)","index":4,"n_rows":23,"n_cols":11,"rows_kept":23,"cut":false,"hidden":true,"merged":[[1,0,2,1]]}
[]
["雇用保険法第１８条第１項及び第２項により自動変更される額",null,"2023-08-01","適用",15430,"円","①"]
[null,null,"2024-08-01","適用",15690,"円","②"]
[]
["育児休業"]
[null,"開始日",{"$f":"IF('計算書入力例(新規)'!V16=\"\",'計算書入力例(新規)'!Y11,'計算書入力例(新規)'!Y17)","v":"2025-02-21"}]
[null,"終了日",{"$f":"IF('計算書入力例(新規)'!V17=\"\",'計算書入力例(新規)'!Y12,'計算書入力例(新規)'!Y18)","v":"2025-12-25"}]
[null,"180日到達日",{"$f":"IF(OR(C6=\"\",C7=\"\"),\"\",IF((C7-C6+1)<180,\"180日未満\",C6+179))","v":"2025-08-19"}]
[]
["日数等"]
[null,"育児休業期間",{"$f":"IF(OR(C6=\"\",C7=\"\"),0,C7-C6+1)","v":308},"日"]
[null,"給付率67/100日数",{"$f":"IF(OR(C6=\"\",C7=\"\"),0,IF(C8=\"180日未満\",NETWORKDAYS(C6,C7),NETWORKDAYS(C6,C8)))","v":128},"日",null,"①",{"$f":"IF(OR(C6=\"\",C7=\"\"),0,IF(C8=\"180日未満\",IF(C7<C3,NETWORKDAYS(C6,C7),IF(C6<C3,NETWORKDAYS(C6,C3-1),0)),IF(C7<C3,NETWORKDAYS(C6,C3-1),IF(C6<C3,IF(C8<C3,NETWORKDAYS(C6,C8),NETWORKDAYS(C6,C3-1)),0))))","v":0},"日","②",{"$f":"IF(OR(C6=\"\",C7=\"\"),0,IF(C8=\"180日未満\",IF(C7<C3,0,IF(C6<C3,NETWORKDAYS(C3,C7),NETWORKDAYS(C6,C7))),IF(C7<C3,0,IF(C6<C3,IF(C8<C3,0,NETWORKDAYS(C3,C8)),NETWORKDAYS(C6,C8)))))","v":128},"日"]
[null,"給付率50/100日数",{"$f":"IF(OR(C6=\"\",C7=\"\"),0,IF(OR(C8=\"180日未満\",C7=C6+179),0,NETWORKDAYS(C8+1,C7)))","v":92},"日",null,"①",{"$f":"IF(OR(C6=\"\",C7=\"\"),0,IF(OR(C8=\"180日未満\",C7=C6+179),0,IF(C7<C3,NETWORKDAYS(C8+1,C7),IF(C6<C3,IF(C8<C3,NETWORKDAYS(C8+1,C3-1),0),0))))","v":0},"日","②",{"$f":"IF(OR(C6=\"\",C7=\"\"),0,IF(OR(C8=\"180日未満\",C7=C6+179),0,IF(C7<C3,0,IF(C6<C3,IF(C8<C3,NETWORKDAYS(C3,C7),NETWORKDAYS(C8+1,C7)),NETWORKDAYS(C8+1,C7)))))","v":92},"日"]
[]
["再取得"]
[null,"開始日",{"$f":"IF('計算書入力例(新規)'!V16=\"\",\"\",'計算書入力例(新規)'!Y19)","v":""}]
[null,"終了日",{"$f":"IF('計算書入力例(新規)'!V16=\"\",\"\",'計算書入力例(新規)'!Y20)","v":""}]
[null,"180日到達日",{"$f":"IF('計算書入力例(新規)'!V16=\"\",\"\",IF(OR(C8=\"\",C8=\"180日未満\"),IF(((C7-C6+1)+(C17-C16+1))<180,\"180日未満\",C16+179-(C7-C6+1)),\"×\"))","v":""}]
[]
["再取得日数等"]
[null,"育児休業期間",{"$f":"IF(OR(C16=\"\",C17=\"\"),0,C17-C16+1)","v":0},"日"]
[null,"給付率67/100日数",{"$f":"IF(OR('計算書入力例(新規)'!V16=\"\",C18=\"×\"),0,IF(C18=\"180日未満\",NETWORKDAYS(C16,C17),NETWORKDAYS(C16,C18)))","v":0},"日",null,"①",{"$f":"IF(OR('計算書入力例(新規)'!V16=\"\",C18=\"×\"),0,IF(C18=\"180日未満\",IF(C17<C3,NETWORKDAYS(C16,C17),IF(C16<C3,NETWORKDAYS(C16,C3-1),0)),IF(C17<C3,NETWORKDAYS(C16,C18),IF(C16<C3,IF(C18<C3,NETWORKDAYS(C16,C18),NETWORKDAYS(C16,C3-1)),0))))","v":0},"日","②",{"$f":"IF(OR('計算書入力例(新規)'!V16=\"\",C18=\"×\"),0,IF(C18=\"180日未満\",IF(C17<C3,0,IF(C16<C3,NETWORKDAYS(C3,C17),NETWORKDAYS(C16,C17))),IF(C17<C3,0,IF(C16<C3,IF(C18<C3,0,NETWORKDAYS(C3,C18)),NETWORKDAYS(C16,C18)))))","v":0},"日"]
[null,"給付率50/100日数",{"$f":"IF('計算書入力例(新規)'!V16=\"\",0,IF(C18=\"180日未満\",0,IF(C18=\"×\",NETWORKDAYS(C16,C17),NETWORKDAYS(C18+1,C17))))","v":0},"日",null,"①",{"$f":"IF('計算書入力例(新規)'!V16=\"\",0,IF(C18=\"180日未満\",0,IF(C18=\"×\",IF(C17<C3,NETWORKDAYS(C16,C17),IF(C16<C3,NETWORKDAYS(C16,C3-1),0)),IF(C17<C3,NETWORKDAYS(C18+1,C17),IF(C16<C3,IF(C18<C3,NETWORKDAYS(C18+1,C3-1),0),0)))))","v":0},"日","②",{"$f":"IF('計算書入力例(新規)'!V16=\"\",0,IF(C18=\"180日未満\",0,IF(C18=\"×\",IF(C17<C3,0,IF(C16<C3,NETWORKDAYS(C3,C17),NETWORKDAYS(C16,C17))),IF(C17<C3,0,IF(C18<C3,IF(C18<C3,NETWORKDAYS(C3,C17),NETWORKDAYS(C18+1,C17)),NETWORKDAYS(C18+1,C17))))))","v":0},"日"]

{"sheet":"設定 (3)","index":5,"n_rows":23,"n_cols":11,"rows_kept":23,"cut":false,"hidden":true,"merged":[[1,0,2,1]]}
[]
["雇用保険法第１８条第１項及び第２項により自動変更される額",null,"2023-08-01","適用",15430,"円","①"]
[null,null,"2024-08-01","適用",15690,"円","②"]
[]
["育児休業"]
[null,"開始日",{"$f":"IF('計算書入力例 (再取得)'!V16=\"\",'計算書入力例 (再取得)'!Y11,'計算書入力例 (再取得)'!Y17)","v":"2024-06-27"}]
[null,"終了日",{"$f":"IF('計算書入力例 (再取得)'!V17=\"\",'計算書入力例 (再取得)'!Y12,'計算書入力例 (再取得)'!Y18)","v":"2024-12-20"}]
[null,"180日到達日",{"$f":"IF(OR(C6=\"\",C7=\"\"),\"\",IF((C7-C6+1)<180,\"180日未満\",C6+179))","v":"180日未満"}]
[]
["日数等"]
[null,"育児休業期間",{"$f":"IF(OR(C6=\"\",C7=\"\"),0,C7-C6+1)","v":177},"日"]
[null,"給付率67/100日数",{"$f":"IF(OR(C6=\"\",C7=\"\"),0,IF(C8=\"180日未満\",NETWORKDAYS(C6,C7),NETWORKDAYS(C6,C8)))","v":127},"日",null,"①",{"$f":"IF(OR(C6=\"\",C7=\"\"),0,IF(C8=\"180日未満\",IF(C7<C3,NETWORKDAYS(C6,C7),IF(C6<C3,NETWORKDAYS(C6,C3-1),0)),IF(C7<C3,NETWORKDAYS(C6,C3-1),IF(C6<C3,IF(C8<C3,NETWORKDAYS(C6,C8),NETWORKDAYS(C6,C3-1)),0))))","v":25},"日","②",{"$f":"IF(OR(C6=\"\",C7=\"\"),0,IF(C8=\"180日未満\",IF(C7<C3,0,IF(C6<C3,NETWORKDAYS(C3,C7),NETWORKDAYS(C6,C7))),IF(C7<C3,0,IF(C6<C3,IF(C8<C3,0,NETWORKDAYS(C3,C8)),NETWORKDAYS(C6,C8)))))","v":102},"日"]
[null,"給付率50/100日数",{"$f":"IF(OR(C6=\"\",C7=\"\"),0,IF(OR(C8=\"180日未満\",C7=C6+179),0,NETWORKDAYS(C8+1,C7)))","v":0},"日",null,"①",{"$f":"IF(OR(C6=\"\",C7=\"\"),0,IF(OR(C8=\"180日未満\",C7=C6+179),0,IF(C7<C3,NETWORKDAYS(C8+1,C7),IF(C6<C3,IF(C8<C3,NETWORKDAYS(C8+1,C3-1),0),0))))","v":0},"日","②",{"$f":"IF(OR(C6=\"\",C7=\"\"),0,IF(OR(C8=\"180日未満\",C7=C6+179),0,IF(C7<C3,0,IF(C6<C3,IF(C8<C3,NETWORKDAYS(C3,C7),NETWORKDAYS(C8+1,C7)),NETWORKDAYS(C8+1,C7)))))","v":0},"日"]
[]
["再取得"]
[null,"開始日",{"$f":"IF('計算書入力例 (再取得)'!V16=\"\",\"\",'計算書入力例 (再取得)'!Y19)","v":"2025-02-04"}]
[null,"終了日",{"$f":"IF('計算書入力例 (再取得)'!V16=\"\",\"\",'計算書入力例 (再取得)'!Y20)","v":"2025-05-27"}]
[null,"180日到達日",{"$f":"IF('計算書入力例 (再取得)'!V16=\"\",\"\",IF(OR(C8=\"\",C8=\"180日未満\"),IF(((C7-C6+1)+(C17-C16+1))<180,\"180日未満\",C16+179-(C7-C6+1)),\"×\"))","v":"2025-02-06"}]
[]
["再取得日数等"]
[null,"育児休業期間",{"$f":"IF(OR(C16=\"\",C17=\"\"),0,C17-C16+1)","v":113},"日"]
[null,"給付率67/100日数",{"$f":"IF(OR('計算書入力例 (再取得)'!V16=\"\",C18=\"×\"),0,IF(C18=\"180日未満\",NETWORKDAYS(C16,C17),NETWORKDAYS(C16,C18)))","v":3},"日",null,"①",{"$f":"IF(OR('計算書入力例 (再取得)'!V16=\"\",C18=\"×\"),0,IF(C18=\"180日未満\",IF(C17<C3,NETWORKDAYS(C16,C17),IF(C16<C3,NETWORKDAYS(C16,C3-1),0)),IF(C17<C3,NETWORKDAYS(C16,C18),IF(C16<C3,IF(C18<C3,NETWORKDAYS(C16,C18),NETWORKDAYS(C16,C3-1)),0))))","v":0},"日","②",{"$f":"IF(OR('計算書入力例 (再取得)'!V16=\"\",C18=\"×\"),0,IF(C18=\"180日未満\",IF(C17<C3,0,IF(C16<C3,NETWORKDAYS(C3,C17),NETWORKDAYS(C16,C17))),IF(C17<C3,0,IF(C16<C3,IF(C18<C3,0,NETWORKDAYS(C3,C18)),NETWORKDAYS(C16,C18)))))","v":3},"日"]
[null,"給付率50/100日数",{"$f":"IF('計算書入力例 (再取得)'!V16=\"\",0,IF(C18=\"180日未満\",0,IF(C18=\"×\",NETWORKDAYS(C16,C17),NETWORKDAYS(C18+1,C17))))","v":78},"日",null,"①",{"$f":"IF('計算書入力例 (再取得)'!V16=\"\",0,IF(C18=\"180日未満\",0,IF(C18=\"×\",IF(C17<C3,NETWORKDAYS(C16,C17),IF(C16<C3,NETWORKDAYS(C16,C3-1),0)),IF(C17<C3,NETWORKDAYS(C18+1,C17),IF(C16<C3,IF(C18<C3,NETWORKDAYS(C18+1,C3-1),0),0)))))","v":0},"日","②",{"$f":"IF('計算書入力例 (再取得)'!V16=\"\",0,IF(C18=\"180日未満\",0,IF(C18=\"×\",IF(C17<C3,0,IF(C16<C3,NETWORKDAYS(C3,C17),NETWORKDAYS(C16,C17))),IF(C17<C3,0,IF(C18<C3,IF(C18<C3,NETWORKDAYS(C3,C17),NETWORKDAYS(C18+1,C17)),NETWORKDAYS(C18+1,C17))))))","v":78},"日"]