起止日期 各年度月數與租金 (14732)

H4:H9=IF($A4="","",INDEX(FREQUENCY(DATE(H$2,ROW($1:$12),1),EOMONTH(N(IF({1},$B4:$C4)),-1)),2))

I4:I9=IF($A4="","",H4*$A4)

H4:I9複製到 J4:Q9