Excel - Data Extraction based on Dates

Hi

I am trying to extract fee costs depending on time period, but struggling how to approach it with If formulas etc due to the permatations. Essentially, I want to know how much of the fee is applicable to 2014 and how much from 2015 onwards.

In the below fabricated data, 1st line wouldn't be relevent as finishes before 01/01/2014. Second line, I only want to know how much of the 1000 is applicable in 2014...line 4 I need to state how much of the fee is in 2014 and how much is 2015 onwards. As you can see due to the different possibilities, its not a straight forward as first seems. Any help as to how to approach this, would be greatly appreciated as I need to submit this data ASAP to senior mgt

fee start end
1000 01/01/2012 31/12/2013
1000 01/01/2012 30/04/2014
1000 01/01/2012 31/12/2014
1000 01/01/2012 30/04/2016
1000 01/01/2014 31/12/2014
1000 01/01/2014 30/04/2016
1000 01/05/2014 31/12/2014
1000 01/05/2014 30/04/2016
1000 01/01/2015 30/04/2016
1000 01/05/2015 30/04/2016
1000 01/01/2015 01/05/2015
1000 01/05/2015 31/12/2015