E2 下拉{=IFERROR(SMALL(IF(ISNUMBER(0/(MOD((C$2&-C$3&-ROW($1:$31))-2,7)<5)*(MONTH(C$2&-C$3&-ROW($1:$31))=C$3)),ROW($1:$31)),ROW(A1)),"")
另解{=IFERROR(SMALL(IF(MOD((C$2&-C$3&-ROW(INDIRECT("1:"&DAY(EOMONTH(C$2&-C$3,0)))))-2,7)<5,ROW(INDIRECT("1:"&DAY(EOMONTH(C$2&-C$3,0))))),ROW(A1)),"")
留言
張貼留言