{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["日付を求める","条件付き書式","VBAマクロ"],"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":"日付を求める","index":0,"n_rows":8,"n_cols":8,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[null,"第◯の◯曜日の日付を求める",null,null,null,null,"曜日","曜日番号"]
[null,2024,"年","月の初日",null,null,"日曜日",1]
[null,7,"月",{"$f":"WEEKDAY(DATE(B2,B3,1))","v":2},null,null,"月曜日",2]
["第",1,"週","曜日番号",null,null,"火曜日",3]
[null,"金曜日",null,{"$f":"VLOOKUP(B5,$G$2:$H$8,2,0)","v":6},null,null,"水曜日",4]
[null,"は",null,null,null,null,"木曜日",5]
[null,{"$f":"DATE(B2,B3,1+MOD(D5+7-D3,7)+7*(B4-1))","v":"2024-07-05"},"です。",null,null,null,"金曜日",6]
[null,null,null,null,null,null,"土曜日",7]

{"sheet":"条件付き書式","index":1,"n_rows":34,"n_cols":10,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[2024,7,"カレンダー",null,null,"1回目","2回目"]
["年","月",null,null,"1日の曜日番号",{"$f":"WEEKDAY($A$4)","v":2},{"$f":"WEEKDAY($A$4)","v":2},null,"曜日","曜日番号"]
["日付","曜日","予定",null,"第(X)週",1,3,null,"日曜日",1]
[{"$f":"DATE($A$1,$B$1,1)","v":"2024-07-01"},{"$f":"TEXT(A4,\"aaa\")","v":"月"},null,null,"求めたい曜日番号",6,6,null,"月曜日",2]
[{"$f":"_xlfn.IFS(A4=EOMONTH($A$4,0),\"\",A4=\"\",\"\",A4<>EOMONTH($A$4,0),+A4+1)","v":"2024-07-02"},{"$f":"TEXT(A5,\"aaa\")","v":"火"},null,null,"差分(α)",{"$f":"MOD(F4+7-F2,7)","v":4},{"$f":"MOD(G4+7-G2,7)","v":4},null,"火曜日",3]
[{"$f":"_xlfn.IFS(A5=EOMONTH($A$4,0),\"\",A5=\"\",\"\",A5<>EOMONTH($A$4,0),+A5+1)","v":"2024-07-03"},"水",null,null,"求める日付",{"$f":"DATE($A$1,$B$1,1+F5+7*(F3-1))","v":"2024-07-05"},{"$f":"DATE($A$1,$B$1,1+G5+7*(G3-1))","v":"2024-07-19"},null,"水曜日",4]
[{"$f":"_xlfn.IFS(A6=EOMONTH($A$4,0),\"\",A6=\"\",\"\",A6<>EOMONTH($A$4,0),+A6+1)","v":"2024-07-04"},"木",null,null,null,null,null,null,"木曜日",5]
[{"$f":"_xlfn.IFS(A7=EOMONTH($A$4,0),\"\",A7=\"\",\"\",A7<>EOMONTH($A$4,0),+A7+1)","v":"2024-07-05"},"金",null,null,null,null,null,null,"金曜日",6]
[{"$f":"_xlfn.IFS(A8=EOMONTH($A$4,0),\"\",A8=\"\",\"\",A8<>EOMONTH($A$4,0),+A8+1)","v":"2024-07-06"},"土",null,null,null,null,null,null,"土曜日",7]
[{"$f":"_xlfn.IFS(A9=EOMONTH($A$4,0),\"\",A9=\"\",\"\",A9<>EOMONTH($A$4,0),+A9+1)","v":"2024-07-07"},"日"]
[{"$f":"_xlfn.IFS(A10=EOMONTH($A$4,0),\"\",A10=\"\",\"\",A10<>EOMONTH($A$4,0),+A10+1)","v":"2024-07-08"},"月"]
[{"$f":"_xlfn.IFS(A11=EOMONTH($A$4,0),\"\",A11=\"\",\"\",A11<>EOMONTH($A$4,0),+A11+1)","v":"2024-07-09"},"火"]
[{"$f":"_xlfn.IFS(A12=EOMONTH($A$4,0),\"\",A12=\"\",\"\",A12<>EOMONTH($A$4,0),+A12+1)","v":"2024-07-10"},"水"]
[{"$f":"_xlfn.IFS(A13=EOMONTH($A$4,0),\"\",A13=\"\",\"\",A13<>EOMONTH($A$4,0),+A13+1)","v":"2024-07-11"},"木"]
[{"$f":"_xlfn.IFS(A14=EOMONTH($A$4,0),\"\",A14=\"\",\"\",A14<>EOMONTH($A$4,0),+A14+1)","v":"2024-07-12"},"金"]
[{"$f":"_xlfn.IFS(A15=EOMONTH($A$4,0),\"\",A15=\"\",\"\",A15<>EOMONTH($A$4,0),+A15+1)","v":"2024-07-13"},"土"]
[{"$f":"_xlfn.IFS(A16=EOMONTH($A$4,0),\"\",A16=\"\",\"\",A16<>EOMONTH($A$4,0),+A16+1)","v":"2024-07-14"},"日"]
[{"$f":"_xlfn.IFS(A17=EOMONTH($A$4,0),\"\",A17=\"\",\"\",A17<>EOMONTH($A$4,0),+A17+1)","v":"2024-07-15"},"月"]
[{"$f":"_xlfn.IFS(A18=EOMONTH($A$4,0),\"\",A18=\"\",\"\",A18<>EOMONTH($A$4,0),+A18+1)","v":"2024-07-16"},"火"]
[{"$f":"_xlfn.IFS(A19=EOMONTH($A$4,0),\"\",A19=\"\",\"\",A19<>EOMONTH($A$4,0),+A19+1)","v":"2024-07-17"},"水"]
[{"$f":"_xlfn.IFS(A20=EOMONTH($A$4,0),\"\",A20=\"\",\"\",A20<>EOMONTH($A$4,0),+A20+1)","v":"2024-07-18"},"木"]
[{"$f":"_xlfn.IFS(A21=EOMONTH($A$4,0),\"\",A21=\"\",\"\",A21<>EOMONTH($A$4,0),+A21+1)","v":"2024-07-19"},"金"]
[{"$f":"_xlfn.IFS(A22=EOMONTH($A$4,0),\"\",A22=\"\",\"\",A22<>EOMONTH($A$4,0),+A22+1)","v":"2024-07-20"},"土"]
[{"$f":"_xlfn.IFS(A23=EOMONTH($A$4,0),\"\",A23=\"\",\"\",A23<>EOMONTH($A$4,0),+A23+1)","v":"2024-07-21"},"日"]
[{"$f":"_xlfn.IFS(A24=EOMONTH($A$4,0),\"\",A24=\"\",\"\",A24<>EOMONTH($A$4,0),+A24+1)","v":"2024-07-22"},"月"]
[{"$f":"_xlfn.IFS(A25=EOMONTH($A$4,0),\"\",A25=\"\",\"\",A25<>EOMONTH($A$4,0),+A25+1)","v":"2024-07-23"},"火"]
[{"$f":"_xlfn.IFS(A26=EOMONTH($A$4,0),\"\",A26=\"\",\"\",A26<>EOMONTH($A$4,0),+A26+1)","v":"2024-07-24"},"水"]
[{"$f":"_xlfn.IFS(A27=EOMONTH($A$4,0),\"\",A27=\"\",\"\",A27<>EOMONTH($A$4,0),+A27+1)","v":"2024-07-25"},"木"]
[{"$f":"_xlfn.IFS(A28=EOMONTH($A$4,0),\"\",A28=\"\",\"\",A28<>EOMONTH($A$4,0),+A28+1)","v":"2024-07-26"},"金"]
[{"$f":"_xlfn.IFS(A29=EOMONTH($A$4,0),\"\",A29=\"\",\"\",A29<>EOMONTH($A$4,0),+A29+1)","v":"2024-07-27"},"土"]
[{"$f":"_xlfn.IFS(A30=EOMONTH($A$4,0),\"\",A30=\"\",\"\",A30<>EOMONTH($A$4,0),+A30+1)","v":"2024-07-28"},"日"]
[{"$f":"_xlfn.IFS(A31=EOMONTH($A$4,0),\"\",A31=\"\",\"\",A31<>EOMONTH($A$4,0),+A31+1)","v":"2024-07-29"},"月"]
[{"$f":"_xlfn.IFS(A32=EOMONTH($A$4,0),\"\",A32=\"\",\"\",A32<>EOMONTH($A$4,0),+A32+1)","v":"2024-07-30"},"火"]
[{"$f":"_xlfn.IFS(A33=EOMONTH($A$4,0),\"\",A33=\"\",\"\",A33<>EOMONTH($A$4,0),+A33+1)","v":"2024-07-31"},"水"]

{"sheet":"VBAマクロ","index":2,"n_rows":34,"n_cols":10,"rows_kept":34,"cut":false,"hidden":false,"merged":[[3,5,3,6]]}
[2024,7,"カレンダー",null,null,"1回目","2回目"]
["年","月",null,null,"第(X)週",1,3,null,"曜日","曜日番号"]
["日付","曜日","予定",null,"求めたい曜日番号",6,6,null,"日曜日",1]
[{"$f":"DATE($A$1,$B$1,1)","v":"2024-07-01"},{"$f":"TEXT(A4,\"aaa\")","v":"月"},null,null,"予定名称","定例会議",null,null,"月曜日",2]
[{"$f":"_xlfn.IFS(A4=EOMONTH($A$4,0),\"\",A4=\"\",\"\",A4<>EOMONTH($A$4,0),+A4+1)","v":"2024-07-02"},{"$f":"TEXT(A5,\"aaa\")","v":"火"},null,null,null,null,null,null,"火曜日",3]
[{"$f":"_xlfn.IFS(A5=EOMONTH($A$4,0),\"\",A5=\"\",\"\",A5<>EOMONTH($A$4,0),+A5+1)","v":"2024-07-03"},"水",null,null,null,null,null,null,"水曜日",4]
[{"$f":"_xlfn.IFS(A6=EOMONTH($A$4,0),\"\",A6=\"\",\"\",A6<>EOMONTH($A$4,0),+A6+1)","v":"2024-07-04"},"木",null,null,null,null,null,null,"木曜日",5]
[{"$f":"_xlfn.IFS(A7=EOMONTH($A$4,0),\"\",A7=\"\",\"\",A7<>EOMONTH($A$4,0),+A7+1)","v":"2024-07-05"},"金","定例会議",null,null,null,null,null,"金曜日",6]
[{"$f":"_xlfn.IFS(A8=EOMONTH($A$4,0),\"\",A8=\"\",\"\",A8<>EOMONTH($A$4,0),+A8+1)","v":"2024-07-06"},"土",null,null,null,null,null,null,"土曜日",7]
[{"$f":"_xlfn.IFS(A9=EOMONTH($A$4,0),\"\",A9=\"\",\"\",A9<>EOMONTH($A$4,0),+A9+1)","v":"2024-07-07"},"日"]
[{"$f":"_xlfn.IFS(A10=EOMONTH($A$4,0),\"\",A10=\"\",\"\",A10<>EOMONTH($A$4,0),+A10+1)","v":"2024-07-08"},"月"]
[{"$f":"_xlfn.IFS(A11=EOMONTH($A$4,0),\"\",A11=\"\",\"\",A11<>EOMONTH($A$4,0),+A11+1)","v":"2024-07-09"},"火"]
[{"$f":"_xlfn.IFS(A12=EOMONTH($A$4,0),\"\",A12=\"\",\"\",A12<>EOMONTH($A$4,0),+A12+1)","v":"2024-07-10"},"水"]
[{"$f":"_xlfn.IFS(A13=EOMONTH($A$4,0),\"\",A13=\"\",\"\",A13<>EOMONTH($A$4,0),+A13+1)","v":"2024-07-11"},"木"]
[{"$f":"_xlfn.IFS(A14=EOMONTH($A$4,0),\"\",A14=\"\",\"\",A14<>EOMONTH($A$4,0),+A14+1)","v":"2024-07-12"},"金"]
[{"$f":"_xlfn.IFS(A15=EOMONTH($A$4,0),\"\",A15=\"\",\"\",A15<>EOMONTH($A$4,0),+A15+1)","v":"2024-07-13"},"土"]
[{"$f":"_xlfn.IFS(A16=EOMONTH($A$4,0),\"\",A16=\"\",\"\",A16<>EOMONTH($A$4,0),+A16+1)","v":"2024-07-14"},"日"]
[{"$f":"_xlfn.IFS(A17=EOMONTH($A$4,0),\"\",A17=\"\",\"\",A17<>EOMONTH($A$4,0),+A17+1)","v":"2024-07-15"},"月"]
[{"$f":"_xlfn.IFS(A18=EOMONTH($A$4,0),\"\",A18=\"\",\"\",A18<>EOMONTH($A$4,0),+A18+1)","v":"2024-07-16"},"火"]
[{"$f":"_xlfn.IFS(A19=EOMONTH($A$4,0),\"\",A19=\"\",\"\",A19<>EOMONTH($A$4,0),+A19+1)","v":"2024-07-17"},"水"]
[{"$f":"_xlfn.IFS(A20=EOMONTH($A$4,0),\"\",A20=\"\",\"\",A20<>EOMONTH($A$4,0),+A20+1)","v":"2024-07-18"},"木"]
[{"$f":"_xlfn.IFS(A21=EOMONTH($A$4,0),\"\",A21=\"\",\"\",A21<>EOMONTH($A$4,0),+A21+1)","v":"2024-07-19"},"金","定例会議"]
[{"$f":"_xlfn.IFS(A22=EOMONTH($A$4,0),\"\",A22=\"\",\"\",A22<>EOMONTH($A$4,0),+A22+1)","v":"2024-07-20"},"土"]
[{"$f":"_xlfn.IFS(A23=EOMONTH($A$4,0),\"\",A23=\"\",\"\",A23<>EOMONTH($A$4,0),+A23+1)","v":"2024-07-21"},"日"]
[{"$f":"_xlfn.IFS(A24=EOMONTH($A$4,0),\"\",A24=\"\",\"\",A24<>EOMONTH($A$4,0),+A24+1)","v":"2024-07-22"},"月"]
[{"$f":"_xlfn.IFS(A25=EOMONTH($A$4,0),\"\",A25=\"\",\"\",A25<>EOMONTH($A$4,0),+A25+1)","v":"2024-07-23"},"火"]
[{"$f":"_xlfn.IFS(A26=EOMONTH($A$4,0),\"\",A26=\"\",\"\",A26<>EOMONTH($A$4,0),+A26+1)","v":"2024-07-24"},"水"]
[{"$f":"_xlfn.IFS(A27=EOMONTH($A$4,0),\"\",A27=\"\",\"\",A27<>EOMONTH($A$4,0),+A27+1)","v":"2024-07-25"},"木"]
[{"$f":"_xlfn.IFS(A28=EOMONTH($A$4,0),\"\",A28=\"\",\"\",A28<>EOMONTH($A$4,0),+A28+1)","v":"2024-07-26"},"金"]
[{"$f":"_xlfn.IFS(A29=EOMONTH($A$4,0),\"\",A29=\"\",\"\",A29<>EOMONTH($A$4,0),+A29+1)","v":"2024-07-27"},"土"]
[{"$f":"_xlfn.IFS(A30=EOMONTH($A$4,0),\"\",A30=\"\",\"\",A30<>EOMONTH($A$4,0),+A30+1)","v":"2024-07-28"},"日"]
[{"$f":"_xlfn.IFS(A31=EOMONTH($A$4,0),\"\",A31=\"\",\"\",A31<>EOMONTH($A$4,0),+A31+1)","v":"2024-07-29"},"月"]
[{"$f":"_xlfn.IFS(A32=EOMONTH($A$4,0),\"\",A32=\"\",\"\",A32<>EOMONTH($A$4,0),+A32+1)","v":"2024-07-30"},"火"]
[{"$f":"_xlfn.IFS(A33=EOMONTH($A$4,0),\"\",A33=\"\",\"\",A33<>EOMONTH($A$4,0),+A33+1)","v":"2024-07-31"},"水"]