I have the following formula that I would like to shorten if possible. This
is as compact as I can get it....any suggestions?


=IF(J$4$H5+MIN($D5,$E5),IF($E5=$D5,MIN($E5-$D5,DAYS360($H5+MIN($D5,$E5),J$4,FALSE))/30*($C5/12)-MIN($E5-$D5,MAX(DAYS360($H5+$I5*30+MIN($E5,$D5),J$4,FALSE) ,0))/30*($C5/12),MIN($D5-$E5,DAYS360($H5+MIN($D5,$E5),J$4,FALSE))/30*(-$C5/12)+MIN($D5-$E5,MAX(DAYS360($H5+$I5+MIN($D5,$E5)*30,J$4,FALSE) ,0))/30*($C5/12)),0)