I really do need some help with this problem. An attached worksheet is included:

Questions:
1. What do I need in the formula so that the partial month start dates and end dates are recognized in the quarterly calculation formulas. For example, I think there should be a value showing in cell O5 because the start date in cell B5 is between 06/30/14 and 09/29/14.

2. Is there a simpler formula that will recognize the start and end dates, apply the ramp-up rates, and perform the partial
month calculations on an annual basis versus quarterly basis?

Thanks so much.