D2:D7{=IFERROR(SMALL(IF((WEEKDAY(DATE(B$2,B$6,ROW($1:$32)),2)<6)*((WEEKDAY(DATE(B$2,B$6,ROW($1:$32)-1),2)>5)+(MONTH(DATE(B$2,B$6,ROW($1:$32)-1))<>B$6))*(MONTH(DATE(B$2,B$6,ROW($1:$32)))=B$6),ROW($1:$32)),ROW(A1)),"")
E2:E7{=IF(D2="","",SMALL(IF((WEEKDAY(DATE(B$2,B$6,ROW($1:$31)),2)<6)*((WEEKDAY(DATE(B$2,B$6,ROW($1:$31)+1),2)>5)+(MONTH(DATE(B$2,B$6,ROW($1:$31)+1))<>B$6))*(MONTH(DATE(B$2,B$6,ROW($1:$31)))=B$6),ROW($1:$31)),ROW(A1)))
I1:O16格式化=(COLUMN(A1)=$B$10)*(I1>0)
留言
張貼留言