How to calculate number of months by date range for a specific year?

Hello,

Hoping someone can help me with this.

I have date ranges for contracts similar to below:

Column G / Column H / Column O
Start Date / End Date / Payment amount
2006-04-01 / 2010-04-01 / 577.9700
2011-12-15 / 2014-12-15 / 407.61


I'm using pivot table to report on a bunch of the information, one of which would be something similar to:

How much money was collected in 2010, 2011, 2012, 2013, 2014, 2015

I'm not sure how to extrapolate that data from the date ranges. In the above example, if we were looking at 2014, then it should end up being 12*407.61 since they were charged 12 times in 2014.

I have hundreds of contracts to sort through, is there an easy way of doing this?


Thanks!

smth like that

Thanks!

I used your formula and tweaked it a bit for my formatting but it's doing exactly what i need.

Hope you have a great weekend!