Recurring Revenue between two dates

[EmSav]

I am trying to put the same monthly revenue into the correct months based on a start date and end date. I have the formula to equally split the revenue over these months but I would like to have the same number in each box.

I have attached what I currently have and an example of what it should look like.

I'd be grateful for your help!

Current
	Start Date	End Date	Revenue	Jan-19	Feb-19	Mar-19	Apr-19	May-19	Jun-19	Jul-19	Aug-19	Sep-19	Oct-19	Nov-19	Dec-19	Total
Contract 1	01/04/2019	31/12/2019	£10,000				£1,091	£1,127	£1,091	£1,127	£1,127	£1,091	£1,127	£1,091	£1,127	10000
Contract 2	01/05/2019	31/12/2019	£20,000					£2,531	£2,449	£2,531	£2,531	£2,449	£2,531	£2,449	£2,531	20000
Contract 3	01/06/2019	31/12/2019	£30,000						£4,206	£4,346	£4,346	£4,206	£4,346	£4,206	£4,346	30000
WHAT I NEED IT TO BE
	Start Date	End Date	Revenue	Jan-19	Feb-19	Mar-19	Apr-19	May-19	Jun-19	Jul-19	Aug-19	Sep-19	Oct-19	Nov-19	Dec-19	Total
Contract 1	01/04/2019	31/12/2019	£10,000				£10,000	£10,000	£10,000	£10,000	£10,000	£10,000	£10,000	£10,000	£10,000	90000
Contract 2	01/05/2019	31/12/2019	£20,000					£20,000	£20,000	£20,000	£20,000	£20,000	£20,000	£20,000	£20,000	160000
Contract 3	01/06/2019	31/12/2019	£30,000						£30,000	£30,000	£30,000	£30,000	£30,000	£30,000	£30,000	210000

<colgroup><col><col span="16"></colgroup><tbody>
</tbody>

 

[mrshl9898]

How about in E2?

=IF(AND(E$1>=$B2,EOMONTH(E$1,0)<=$C2),$D2,"")