每月天数自动计算 (12749)

E2 右拉 下拉=SUM(FREQUENCY(ROW(INDIRECT($C2&":"&$D2)),EOMONTH(E$1-{1,0},0))*{0;1;0})

另解{=SUM((ROW(INDIRECT($C2&":"&$D2))<=(EDATE(E$1,1)-1))*(ROW(INDIRECT($C2&":"&$D2))>=E$1))

另解=SUMPRODUCT((TEXT(ROW(INDIRECT($C2&":"&$D2)),"emm")=TEXT(E$1,"emm"))*1)

另解=MAX(MIN($D2,EOMONTH(E$1,0))-MAX($C2-1,EOMONTH(E$1,-1)),)