如图例,A1为起始日,B1为截止日,统计期间有几个31日
C1=SUMPRODUCT(N(DAY(ROW(INDIRECT(A1&":"&B1)))=31))
或=COUNT(0/(DAY(ROW(INDIRECT(A1&":"&B1)))=31))----数组公式