I have used the following formula. Check it and see if it fulfills your requirement.
=IF(OR(EOMONTH($F$10,0)<B11,EOMONTH($F$10,0)<$C$11),E11-SUM(F11:K11),IF(OR(EOMONTH($G$10,0)<B11,EOMONTH($G$10,0)<$C$11),E11-SUM(F11:K11),IF(OR(EOMONTH($H$10,0)<B11,EOMONTH($H$10,0)<$C$11),E11-SUM(F11:K11),IF(OR(EOMONTH($I$10,0)<B11,EOMONTH($I$10,0)<$C$11),E11-SUM(F11:K11),IF(OR(EOMONTH($J$10,0)<B11,EOMONTH($J$10,0)<$C$11),E11-SUM(F11:K11),IF(OR(EOMONTH($K$10,0)<B11,EOMONTH($K$10,0)<$C$11),E11-SUM(F11:K11),0))))))
Bookmarks