計算日期 依周別 星期 (11657)

D2=$A$3*7-1-MOD(MOD((D$1&-$C2&-1)-2,7)-$A$6,7)+(D$1&-$C2&-1)

另解{=SMALL(IFERROR(IF(WEEKDAY(D$1&-$C2&-ROW($1:$31),2)=$A$6,(D$1&-$C2&-ROW($1:$31))*1),""),$A$3)



留言