不含国定假日=SUMPRODUCT(N(WEEKDAY(ROW(INDIRECT(A$2&":"&B$2)))={1,7}))
含国定假日=SUMPRODUCT(N(WEEKDAY(ROW(INDIRECT(A$2&":"&B$2)))={1,7}))+SUMPRODUCT((F$2:F$99>=A2)*(F$2:F$99<=B2))