隨機不出現周日 依指定年月 (12731)

D2 右拉 下拉{=LARGE((MOD(ROW(INDIRECT(DATE($B$2,$B$3,1)&":"&DATE($B$2,$B$4,DAY(EOMONTH(DATE($B$2,$B$4,1),0)))))-2,7)<6)*ROW(INDIRECT(DATE($B$2,$B$3,1)&":"&DATE($B$2,$B$4,DAY(EOMONTH(DATE($B$2,$B$4,1),0))))),RANDBETWEEN(1,SUM(N(MOD(ROW(INDIRECT(DATE($B$2,$B$3,1)&":"&DATE($B$2,$B$4,DAY(EOMONTH(DATE($B$2,$B$4,1),0)))))-2,7)<6))))

D2:H9格式化 第一日與最後日=(DATE($B$2,$B$3,1)=D2)+(DATE($B$2,$B$4,DAY(EOMONTH(DATE($B$2,$B$4,1),0)))=D2)