起訖日期之間 各月天數 (14706)

D2:O7=TEXT(MIN(EOMONTH(DATE(2025,COLUMN(A1),),1),$C2)-MAX(DATE(2025,COLUMN(A1),1),$B2)+1,"0;;")

另解=TEXT(INDEX(FREQUENCY(MONTH(ROW(INDIRECT($B2&":"&$C2))),ROW($1:$11)),COLUMN(A1)),"0;;")