自動生每期租金及起訖時間 (13467)

A7=IF(ROW(A1)>B$2/B$3,"",TEXT(EDATE(B$1,(ROW(A1)-1)*B$3*12),"yyy/m/d")&" - "&TEXT(EDATE(B$1,ROW(A1)*B$3*12)-1,"yyy/m/d"))

B7=IF(A7="","",IF(ROW(A1)=1,B$5,B6*(1+B$4)))