K4=EDATE(J4,1), copy across.
J8=IF(AND(J$4>=$E8,J$4<=$F8,J$4<$H8),$G8/12*1000,IF(OR(J$4<$E8,J$4>$F8),0,$G8/12*1000*(1+$I8))).