Try pasting the following into cell GN3 and then copying over and down:
Formula:
=IF(OR(GN$2< EOMONTH($BJ3,-1),GN$2>EOMONTH($BK3,0)),"",IF(AND(MONTH($BJ3)=MONTH(GN$2),YEAR($BJ3)=YEAR(GN$2)),$BL3*(EOMONTH($BJ3,0)-$BJ3)/28+$BN3+(($GM3*30.5)/74*($BM3*60))/$GM3+($GM3/3)*$BO3/$GM3,IF(AND(MONTH($BK3)=MONTH(GN$2),YEAR($BK3)=YEAR(GN$2)),($BL3*(EOMONTH($BK3,0)-$BK3)/30.5)+($GM3/3)*$BO3/$GM3+(($GM3*30.5)/74*($BM3*60))/$GM3,$BL3+($GM3/3)*$BO3/$GM3+(($GM3*30.5)/74*($BM3*60))/$GM3)))
Let us know if you have any questions.
Bookmarks