周日~周四 計天数 (11231)

离店日期 不可計=SUMPRODUCT(N(MOD(ROW(INDIRECT(A2&":"&B2-1))+1,7)>1))

另解{=SUM(N(MMULT({1,1},N(TRANSPOSE(MOD(ROW(INDIRECT(A2&":"&B2-1))-2,7))<>{4;5}))=2))

另解=SUMPRODUCT(N(WEEKDAY(ROW(INDIRECT($A2&":"&$B2-1)),1)<6))