{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["読んでください","期間の計算①","期間の計算②","期間の計算③","産休期間算出","年齢の算出","学齢の算出","西暦和暦変換"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":9,"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":"読んでください","index":0,"n_rows":40,"n_cols":14,"rows_kept":40,"cut":false,"hidden":false,"merged":[[29,1,29,2],[29,3,29,4],[24,1,25,3],[29,7,29,10],[24,4,25,5],[18,1,18,3],[18,4,18,5],[21,1,23,3],[19,1,20,3],[19,4,20,5],[21,4,23,5]]}
[]
[]
[null,null,"まずはじめにお読みください （Ver 3.0）",null,null,null,null,null,null,null,null,null,"兵庫県立神戸北高等学校"]
[null,null,null,null,null,null,null,null,null,null,null,null,"校長　長澤 和弥"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"■月単位で計算する場合の基本的な考え方－民法 第143条2項による"]
[]
[null,"場合",null,null,"満了日",null,null,null,null,"具体例"]
[null,"月の初日から起算する場合",null,null,"最終月の末日",null,"1月1日から起算して2月は、平年なら2月28日、閏年なら2月29日が満了日",null,null,null,null,null,null," "]
[null,null,null,null,null,null,"1月1日から起算して3月は、3月31日が満了日",null,null,null,null,null,null," "]
[null,"月の初日以外から起算\nして最終月に応答日のある場合",null,null,"最終月の応答日前日",null,"1月20日から起算して2月は、3月19日が満了日",null,null,null,null,null,null," "]
[null,null,null,null,null,null,"1月31日から起算して2月は、3月30日が満了日",null,null,null,null,null,null," "]
[null,null,null,null,null,null,"2月28日から起算して2月は、4月27日が満了日",null,null,null,null,null,null," "]
[null,"月の初日以外から起算\nして最終月に応答日のない場合",null,null,"最終月の末日",null,"1月31日から起算して1月は、平年なら2月28日、閏年なら2月29日が満了日",null,null,null,null,null,null," "]
[null,null,null,null,null,null,"3月31日から起算して1月は、4月30日が満了日",null,null,null,null,null,null," "]
[]
[null,"■末日が関わる期間計算の例"]
[]
[null,"起算日",null,"満了日",null,null,null,"計算の結果と考え方"]
[null,"3月31日",null,"5月31日",null,"応答日前日の5月30日で2月となり、それに加えて1日。2月と1日。",null,null,null,null,null,null,null," "]
[null,"3月31日",null,"4月30日",null,"4月30日が応答日前日となるので、ちょうど1月。",null,null,null,null,null,null,null," "]
[null,"3月31日",null,"2月28日","または29日","応答日前日2月30日はないので、2月末日（28日か29日）で11月ちょうど。",null,null,null,null,null,null,null," "]
[null,"4月30日",null,"5月31日",null,"応答日前日の5月29日でちょうど1月となり、それに加えて2日。1月と2日。",null,null,null,null,null,null,null," "]
[null,"4月30日",null,"6月30日",null,"応答日前日の6月29日で2月となり、それに加えて1日。2月と1日。",null,null,null,null,null,null,null," "]
[null,"4月30日",null,"2月29日","または28日","2月29日は応答日前日となり、ちょうど10月。平年の場合も末日である28日で10月となる。",null,null,null,null,null,null,null," "]
[null,"2月28日","平年","3月31日",null,"応答日前日の3月27日で1月となり、それに加えて4日。1月と4日。",null,null,null,null,null,null,null," "]
[null,"2月29日","閏年","3月31日",null,"応答日前日の3月28日で1月となり、それに加えて3日。1月と3日。",null,null,null,null,null,null,null," "]
[null,"2月28日","平年","2月29日","閏年","応答日前日の2月27日で12月となり、それに加えて2日。12月と2日。",null,null,null,null,null,null,null," "]
[null,"2月29日","閏年","2月28日","平年","2月28日は応答日前日となり、12月ちょうどとなる。",null,null,null,null,null,null,null," "]

{"sheet":"期間の計算①","index":1,"n_rows":39,"n_cols":23,"rows_kept":39,"cut":false,"hidden":false,"merged":[[9,9,9,10],[5,2,5,7],[3,2,3,17],[7,2,7,7],[7,9,7,10],[9,2,9,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,null,null,null,null,null,null,{"$f":"IF(J8=\"西暦\",L8,IF(J8=\"令和\",2018,IF(J8=\"平成\",1988,1925)))","v":1965}]
[null,null,"起算日（から）",null,null,null,null,null,null,"西暦",null,1965,"年",12,"月",7,"日",null,null,null,null,null,{"$f":"IF(J8=\"西暦\",CONCATENATE(TEXT(L8,\"##-\"),TEXT(N8,\"##-\"),TEXT(P8,\"##\")),CONCATENATE(TEXT((L8+U7),\"##-\"),TEXT(N8,\"##-\"),TEXT(P8,\"##\")))","v":"1965-12-7"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J10=\"西暦\",L10,IF(J10=\"令和\",2018,IF(J10=\"平成\",1988,1925)))","v":2018}]
[null,null,"満了日（まで）",null,null,null,null,null,null,"令和",null,2,"年",12,"月",7,"日",null,null,null,null,null,{"$f":"IF(J10=\"西暦\",CONCATENATE(TEXT(L10,\"##-\"),TEXT(N10,\"##-\"),TEXT(P10,\"##\")),CONCATENATE(TEXT((L10+U9),\"##-\"),TEXT(N10,\"##-\"),TEXT(P10,\"##\")))","v":"2020-12-7"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"令和2年（2020年）12月7日　Ver 2.0"]
[]
[]
[]
[null,null,"兵庫県立神戸北高等学校"]
[null,null,"校長"]
[null,null,"長澤 和弥"]

{"sheet":"期間の計算②","index":2,"n_rows":29,"n_cols":19,"rows_kept":29,"cut":false,"hidden":false,"merged":[[3,2,3,15],[5,2,5,7],[7,2,7,7],[7,9,7,10],[9,2,9,7],[9,9,9,10]]}
[]
[null,"起算月と満了月を入力してください。"]
[]
[null,null,"年月数の算出"]
[]
[null,null,"年月数",null,null,null,null,null,null,null,null,{"$f":"S6+DATEDIF(DATEVALUE(S8),DATEVALUE(S10),\"y\")","v":0},"年",{"$f":"IF(DATEDIF(DATEVALUE(S8),DATEVALUE(S10),\"ym\")+1=12,0,DATEDIF(DATEVALUE(S8),DATEVALUE(S10),\"ym\")+1)","v":7},"月",null,null,null,{"$f":"IF(DATEDIF(DATEVALUE(S8),DATEVALUE(S10),\"ym\")+1=12,1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J8=\"西暦\",L8,(IF(J8=\"昭和\",1925,IF(J8=\"平成\",1988,2018))))","v":2018}]
[null,null,"起算月（から）",null,null,null,null,null,null,"令和",null,3,"年",4,"月",null,null,null,{"$f":"IF(J8=\"西暦\",CONCATENATE(TEXT(L8,\"##-\"),TEXT(N8,\"##-\"),\"10\"),CONCATENATE(TEXT((L8+S7),\"##-\"),TEXT(N8,\"##-\"),\"10\"))","v":"2021-4-10"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J10=\"西暦\",L10,(IF(J10=\"昭和\",1925,IF(J10=\"平成\",1988,2018))))","v":2021}]
[null,null,"満了月（まで）",null,null,null,null,null,null,"西暦",null,2021,"年",10,"月",null,null,null,{"$f":"IF(J10=\"西暦\",CONCATENATE(TEXT(L10,\"##-\"),TEXT(N10,\"##-\"),\"15\"),CONCATENATE(TEXT((L10+S9),\"##-\"),TEXT(N10,\"##-\"),\"15\"))","v":"2021-10-15"}]
[]
[]
[null,null,"★給料査定のための経験年数を算出する時などに使います。"]
[null,null,"★入力する最初と最後の月も期間に含まれます。"]
[]
[null,null,"※入力するセル間の移動は、矢印キー、タブキー、マウスなどで。"]
[null,null,"※「起算月」と「満了月」では、和暦と西暦の混在可。"]
[]
[]
[]
[]
[]
[null,null,"令和2年（2020年）12月7日　Ver 2.0"]
[]
[]
[]
[null,null,"兵庫県立神戸北高等学校"]
[null,null,"校長"]
[null,null,"長澤 和弥"]

{"sheet":"期間の計算③","index":3,"n_rows":37,"n_cols":21,"rows_kept":37,"cut":false,"hidden":false,"merged":[[16,2,16,17],[9,9,9,10],[9,2,9,7],[3,2,3,17],[5,2,5,7],[5,9,5,10],[7,2,7,7],[22,12,22,13],[22,2,22,7],[18,2,18,7],[18,9,18,10],[20,2,20,7],[20,9,20,10]]}
[]
[null,"起算日／満了日／日数（期間）を入力してください。"]
[]
[null,null,"看護欠勤等の期間算出 Ⅰ"]
[]
[null,null,"起算日（から）",null,null,null,null,null,null,"令和",null,3,"年",1,"月",4,"日",null,null,null,{"$f":"CONCATENATE(TEXT((L6+2018),\"##-\"),TEXT(N6,\"##-\"),TEXT(P6,\"##\"))","v":"2021-1-4"}]
[]
[null,null,"日数（期間）",null,null,null,null,null,null,null,null,null,null,30,"日間",null,null,null,null,null,{"$f":"(U6+N8)-1","v":44229}]
[]
[null,null,"満了日（まで）",null,null,null,null,null,null,"令和",null,{"$f":"YEAR(U8)-2018","v":3},"年",{"$f":"MONTH(U8)","v":2},"月",{"$f":"DAY(U8)","v":2},"日"]
[]
[]
[null,null,"★上は、看欠・介休など、「○月△日から×日間」の期間の算出に使います。"]
[null,null,"★下は、同じく起算日と満了日を指定した日数算出に使います。"]
[]
[]
[null,null,"看護欠勤等の期間算出 Ⅱ"]
[]
[null,null,"起算日（から）",null,null,null,null,null,null,"令和",null,3,"年",1,"月",4,"日",null,null,null,{"$f":"CONCATENATE(TEXT((L19+2018),\"##-\"),TEXT(N19,\"##-\"),TEXT(P19,\"##\"))","v":"2021-1-4"}]
[]
[null,null,"満了日（まで）",null,null,null,null,null,null,"令和",null,3,"年",2,"月",2,"日",null,null,null,{"$f":"CONCATENATE(TEXT((L21+2018),\"##-\"),TEXT(N21,\"##-\"),TEXT(P21,\"##\"))","v":"2021-2-2"}]
[]
[null,null,"日数（期間）",null,null,null,null,null,null,null,null,null,{"$f":"DATEDIF(DATEVALUE(U19),DATEVALUE(U21),\"d\")+1","v":30},null,"日間"]
[]
[]
[null,null,"※閏年にも対応していますが、令和年間でのみ使えます。"]
[null,null,"※入力するセル間の移動は、矢印キー、タブキー、マウスなどで。"]
[]
[]
[]
[null,null,"令和2年（2020年）12月7日　Ver 2.0"]
[]
[]
[]
[null,null,"兵庫県立神戸北高等学校"]
[null,null,"校長"]
[null,null,"長澤 和弥"]

{"sheet":"産休期間算出","index":4,"n_rows":30,"n_cols":21,"rows_kept":30,"cut":false,"hidden":false,"merged":[[3,2,3,17],[6,2,6,6],[8,2,8,6],[10,2,10,6],[6,8,6,9],[8,8,8,9],[10,8,10,9]]}
[]
[null,"出産予定の年・月・日を入力してください。"]
[]
[null,null,"産前産後休暇期間の算出"]
[]
[]
[null,null,"産前休暇開始",null,null,null,null,null,"令和",null,{"$f":"YEAR(U7)-2018","v":2},"年",{"$f":"MONTH(U7)","v":11},"月",{"$f":"DAY(U7)","v":24},"日から",null,null,null,null,{"$f":"U9-(O14*7)","v":44159}]
[]
[null,null,"出産予定日",null,null,null,null,null,"令和",null,3,"年",1,"月",19,"日",null,null,null,null,{"$f":"CONCATENATE(\"R\",TEXT(K9,\"##.\"),TEXT(M9,\"##.\"),TEXT(O9,\"##\"))","v":"R3.1.19"}]
[]
[null,null,"産後休暇終了",null,null,null,null,null,"令和",null,{"$f":"YEAR(U11)-2018","v":3},"年",{"$f":"MONTH(U11)","v":3},"月",{"$f":"DAY(U11)","v":16},"日まで",null,null,null,null,{"$f":"U9+(8*7)","v":44271}]
[]
[]
[null,null,"★多胎妊娠の場合は、右の数字を 14 に変えること →",null,null,null,null,null,null,null,null,null,null,null,8,"週"]
[null,null,"★閏年にも対応していますが、令和年間にのみ使用できます。"]
[]
[]
[null,null,"※入力するセル間の移動は、矢印キー、タブキー、マウスなどで。"]
[]
[]
[]
[]
[]
[null,null,"令和2年（2020年）12月7日　Ver 2.0"]
[]
[]
[]
[null,null,"兵庫県立神戸北高等学校"]
[null,null,"校長"]
[null,null,"長澤 和弥"]

{"sheet":"年齢の算出","index":5,"n_rows":35,"n_cols":21,"rows_kept":35,"cut":false,"hidden":false,"merged":[[3,2,3,17],[7,9,7,10],[5,2,5,7],[7,2,7,7],[5,12,5,14],[14,2,14,17],[16,12,16,14],[20,2,20,7],[20,9,20,10],[18,2,18,7],[18,9,18,10]]}
[]
[null,"調べたい誕生日（と指定日）を入力してください。"]
[]
[null,null,"本日現在の年齢算出"]
[]
[null,null,{"$f":"TODAY()","v":"2020-12-09"},null,null,null,null,null,"現在の年齢",null,null,null,{"$f":"DATEDIF(DATEVALUE(U8),TODAY(),\"y\")&\"歳 \"&DATEDIF(DATEVALUE(U8),TODAY(),\"ym\")&\"月\"","v":"48歳 3月"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J8=\"西暦\",L8,(IF(J8=\"昭和\",1925,IF(J8=\"平成\",1988,2018))))","v":1925}]
[null,null,"調べる誕生日",null,null,null,null,null,null,"昭和",null,47,"年",8,"月",15,"日",null,null,null,{"$f":"IF(J8=\"西暦\",CONCATENATE(TEXT(U7,\"##-\"),TEXT(N8,\"##-\"),TEXT(P8,\"##\")),CONCATENATE(TEXT((L8+U7),\"##-\"),TEXT(N8,\"##-\"),TEXT(P8,\"##\")))","v":"1972-8-15"}]
[]
[]
[null,null,null,"★閏年にも対応していますが、昭和～令和年間にのみ使用できます。"]
[null,null,null,"★西暦の入力も可です。"]
[]
[]
[null,null,"指定日現在の年齢算出"]
[]
[null,null,null,null,null,null,null,null,null,"指定日現在の年齢",null,null,{"$f":"DATEDIF(DATEVALUE(U21),DATEVALUE(U19),\"y\")&\"歳 \"&DATEDIF(DATEVALUE(U21),DATEVALUE(U19),\"ym\")&\"月\"","v":"46歳 7月"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J19=\"西暦\",L19,(IF(J19=\"昭和\",1925,IF(J19=\"平成\",1988,2018))))","v":2019}]
[null,null,"指定日",null,null,null,null,null,null,"西暦",null,2019,"年",4,"月",1,"日",null,null,null,{"$f":"IF(J19=\"西暦\",CONCATENATE(TEXT(U18,\"##-\"),TEXT(N19,\"##-\"),TEXT(P19,\"##\")),CONCATENATE(TEXT((L19+U18),\"##-\"),TEXT(N19,\"##-\"),TEXT(P19,\"##\")))","v":"2019-4-1"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J21=\"西暦\",L21,(IF(J21=\"昭和\",1925,IF(J21=\"平成\",1988,2018))))","v":1925}]
[null,null,"調べる誕生日",null,null,null,null,null,null,"昭和",null,47,"年",8,"月",15,"日",null,null,null,{"$f":"IF(J21=\"西暦\",CONCATENATE(TEXT(U20,\"##-\"),TEXT(N21,\"##-\"),TEXT(P21,\"##\")),CONCATENATE(TEXT((L21+U20),\"##-\"),TEXT(N21,\"##-\"),TEXT(P21,\"##\")))","v":"1972-8-15"}]
[]
[]
[null,null,"※入力するセル間の移動は、矢印キー、タブキー、マウスなどで。"]
[null,null,"※「指定日現在の年齢算出」では、和暦と西暦の混在可。"]
[]
[]
[]
[null,null,"令和2年（2020年）12月7日　Ver 2.0"]
[]
[]
[]
[null,null,"兵庫県立神戸北高等学校"]
[null,null,"校長"]
[null,null,"長澤 和弥"]

{"sheet":"学齢の算出","index":6,"n_rows":35,"n_cols":22,"rows_kept":35,"cut":false,"hidden":false,"merged":[[3,2,3,17],[7,9,7,10],[5,2,5,7],[7,2,7,7],[14,2,14,17],[20,2,20,7],[20,9,20,10],[18,2,18,7],[18,9,18,10],[5,12,5,15],[16,12,16,15]]}
[]
[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(V5=\"小学校 \",(U6-6)&\"年\",IF(V5=\"中学校 \",(U6-12)&\"年\",IF(V5=\"高校 \",(U6-15)&\"年\",\"\")))","v":"3年"},{"$f":"IF(U6=V6,IF(U6<=12,\"小学校 \",IF(U6>=16,\"高校 \",\"中学校 \")),V6)","v":"中学校 "}]
[null,null,{"$f":"TODAY()","v":"2020-12-09"},null,null,null,null,null,"現在の学齢",null,null,null,{"$f":"V5&U5","v":"中学校 3年"},null,null,null,null,null,null,null,{"$f":"IF(TEXT(U8,\"mmdd\")<\"0402\",DATEDIF(DATE(YEAR(U8)-1,4,1),TODAY(),\"y\"),DATEDIF(DATE(YEAR(U8),4,1),TODAY(),\"y\"))","v":15},{"$f":"IF(U6<7,\"就学前\",IF(U6>18,\"高校卒業以上\",U6))","v":15}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J8=\"西暦\",L8,(IF(J8=\"昭和\",1925,IF(J8=\"平成\",1988,2018))))","v":1988}]
[null,null,"調べる誕生日",null,null,null,null,null,null,"平成",null,17,"年",4,"月",2,"日",null,null,null,{"$f":"IF(J8=\"西暦\",CONCATENATE(TEXT(U7,\"##-\"),TEXT(N8,\"##-\"),TEXT(P8,\"##\")),CONCATENATE(TEXT((L8+U7),\"##-\"),TEXT(N8,\"##-\"),TEXT(P8,\"##\")))","v":"2005-4-2"}]
[]
[]
[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(V16=\"小学校 \",(U17-6)&\"年\",IF(V16=\"中学校 \",(U17-12)&\"年\",IF(V16=\"高校 \",(U17-15)&\"年\",\"\")))","v":"6年"},{"$f":"IF(U17=V17,IF(U17<=12,\"小学校 \",IF(U17>=16,\"高校 \",\"中学校 \")),V17)","v":"小学校 "}]
[null,null,null,null,null,null,null,null,null,"指定日現在の学齢",null,null,{"$f":"V16&U16","v":"小学校 6年"},null,null,null,null,null,null,null,{"$f":"IF(TEXT(U21,\"mmdd\")<\"0402\",DATEDIF(DATE(YEAR(U21)-1,4,1),U19,\"y\"),DATEDIF(DATE(YEAR(U21),4,1),U19,\"y\"))","v":12},{"$f":"IF(U17<7,\"就学前\",IF(U17>18,\"高校卒業以上\",U17))","v":12}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J19=\"西暦\",L19,(IF(J19=\"昭和\",1925,IF(J19=\"平成\",1988,2018))))","v":2018}]
[null,null,"指定日",null,null,null,null,null,null,"令和",null,2,"年",4,"月",1,"日",null,null,null,{"$f":"IF(J19=\"西暦\",CONCATENATE(TEXT(U18,\"##-\"),TEXT(N19,\"##-\"),TEXT(P19,\"##\")),CONCATENATE(TEXT((L19+U18),\"##-\"),TEXT(N19,\"##-\"),TEXT(P19,\"##\")))","v":"2020-4-1"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J21=\"西暦\",L21,(IF(J21=\"昭和\",1925,IF(J21=\"平成\",1988,2018))))","v":2008}]
[null,null,"調べる誕生日",null,null,null,null,null,null,"西暦",null,2008,"年",8,"月",7,"日",null,null,null,{"$f":"IF(J21=\"西暦\",CONCATENATE(TEXT(U20,\"##-\"),TEXT(N21,\"##-\"),TEXT(P21,\"##\")),CONCATENATE(TEXT((L21+U20),\"##-\"),TEXT(N21,\"##-\"),TEXT(P21,\"##\")))","v":"2008-8-7"}]
[]
[]
[null,null,"※入力するセル間の移動は、矢印キー、タブキー、マウスなどで。"]
[null,null,"※「指定日現在の学齢算出」では、和暦と西暦の混在可。"]
[]
[]
[]
[null,null,"令和2年（2020年）12月7日　Ver 2.0"]
[]
[]
[]
[null,null,"兵庫県立神戸北高等学校"]
[null,null,"校長"]
[null,null,"長澤 和弥"]

{"sheet":"西暦和暦変換","index":7,"n_rows":36,"n_cols":19,"rows_kept":36,"cut":false,"hidden":false,"merged":[[20,3,20,9],[22,3,22,9],[18,12,18,13],[18,9,18,11],[20,11,20,13],[22,11,22,13],[3,2,3,15],[5,11,5,13],[16,2,16,15],[7,11,7,13],[9,11,9,13],[7,3,7,9],[9,3,9,9]]}
[]
[null,"調べたい西暦／和暦（昭和・平成・令和）を入力してください。"]
[]
[null,null,"西暦を和暦に変換"]
[]
[null,null,null,"調べたい西暦を入力",null,null,null,null,null,null,null,1960,null,null,"年",null,null,null,{"$f":"IF(L6<1989,\"昭和\",IF(L6<2019,\"平成\",\"令和\"))","v":"昭和"}]
[]
[null,null,null,{"$f":"\"西暦\"&L6&\"年は、\"&S6","v":"西暦1960年は、昭和"},null,null,null,null,null,null,null,{"$f":"IF(S6=\"昭和\",L6-1925,IF(S6=\"平成\",L6-1988,L6-2018))","v":35},{"$f":"IF(M7=\"昭和\",E7-1925,E7-1988)","v":-1988},{"$f":"IF(N7=\"昭和\",F7-1925,F7-1988)","v":-1988},"年"]
[]
[null,null,null,{"$f":"\"西暦\"&L6&\"年は、皇紀\"","v":"西暦1960年は、皇紀"},null,null,null,null,null,null,null,{"$f":"L6+660","v":2620},null,null,"年"]
[]
[]
[null,"★",{"$f":"\"今年は 令和\"&(YEAR(TODAY())-2018)&\"年、皇紀\"&(YEAR(TODAY())+660)&\"年、西暦\"&YEAR(TODAY())&\"年です。\"","v":"今年は 令和2年、皇紀2680年、西暦2020年です。"}]
[null,null,{"$f":"\"（平成では\"&(YEAR(TODAY())-1988)&\"年、昭和では\"&(YEAR(TODAY())-1925)&\"年）\"","v":"（平成では32年、昭和では95年）"}]
[]
[]
[null,null,"和暦を西暦に変換"]
[]
[null,null,null,null,null,null,null,null,"和暦（昭和～令和）","昭和",null,null,35,null,"年",null,null,null,{"$f":"IF(J19=\"昭和\",1925,IF(J19=\"平成\",1988,2018))","v":1925}]
[]
[null,null,null,{"$f":"J19&M19&\"年は、西暦\"","v":"昭和35年は、西暦"},null,null,null,null,null,null,null,{"$f":"M19+S19","v":1960},null,null,"年"]
[]
[null,null,null,{"$f":"J19&M19&\"年は、皇紀\"","v":"昭和35年は、皇紀"},null,null,null,null,null,null,null,{"$f":"L21+660","v":2620},null,null,"年"]
[]
[]
[null,null,"※入力するセル間の移動は、矢印キー、タブキー、マウスなどで。"]
[]
[]
[]
[null,null,"令和2年（2020年）12月7日　Ver 2.0"]
[]
[]
[]
[null,null,"兵庫県立神戸北高等学校"]
[null,null,"校長"]
[null,null,"長澤 和弥"]