指定星期 顯示整年日期 (15309)

D2下拉{=TEXT(DATE(B$2,1,MATCH(B$5,WEEKDAY(B$2&-1&-ROW($1:$9),2),)+ROW(A1)*7-7),"M-DD")

E2下拉=TEXT(DATE(B$2,1,MOD(B$5-WEEKDAY(B$2&-1&-1,2),7)+ROW(A1)*7-6),"M-DD")