输入以下公式=SUMPRODUCT((WEEKDAY(ROW(INDIRECT(A1&":"&B1)),2)=6)*(MOD(DAY(ROW(INDIRECT(A1&":"&B1))),2)=1))+SUMPRODUCT((WEEKDAY(ROW(INDIRECT(A1&":"&B1)),2)
原创 | 2022-11-05 08:26:00 |浏览:1.6万
输入以下公式=SUMPRODUCT((WEEKDAY(ROW(INDIRECT(A1&":"&B1)),2)=6)*(MOD(DAY(ROW(INDIRECT(A1&":"&B1))),2)=1))+SUMPRODUCT((WEEKDAY(ROW(INDIRECT(A1&":"&B1)),2)