Zend certified PHP/Magento developer

How would I go about several contract values among various monthly start and end dates in Excel? Would like to use one dynamic formula if possible

enter image description here

How would I go about several contract values among various monthly start and end dates in Excel? Would like to use one dynamic formula if possible

I’ve tried playing around with it and have come up with this formula so far but the sum of the months doesn’t exactly add up given that there aren’t 30 days in every month

=($E2<=H$1)*(H$1<=$F2)*($D2/(($F2-$E2)/30))