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!

[TABLE="width: 1552"]
<colgroup><col><col span="16"></colgroup><tbody>[TR]
[TD]Current[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]Start Date[/TD]
[TD]End Date[/TD]
[TD]Revenue[/TD]
[TD]Jan-19[/TD]
[TD]Feb-19[/TD]
[TD]Mar-19[/TD]
[TD]Apr-19[/TD]
[TD]May-19[/TD]
[TD]Jun-19[/TD]
[TD]Jul-19[/TD]
[TD]Aug-19[/TD]
[TD]Sep-19[/TD]
[TD]Oct-19[/TD]
[TD]Nov-19[/TD]
[TD]Dec-19[/TD]
[TD]Total[/TD]
[/TR]
[TR]
[TD]Contract 1[/TD]
[TD="align: right"]01/04/2019[/TD]
[TD="align: right"]31/12/2019[/TD]
[TD="align: right"]£10,000[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]£1,091[/TD]
[TD]£1,127[/TD]
[TD]£1,091[/TD]
[TD]£1,127[/TD]
[TD]£1,127[/TD]
[TD]£1,091[/TD]
[TD]£1,127[/TD]
[TD]£1,091[/TD]
[TD]£1,127[/TD]
[TD="align: right"]10000[/TD]
[/TR]
[TR]
[TD]Contract 2[/TD]
[TD="align: right"]01/05/2019[/TD]
[TD="align: right"]31/12/2019[/TD]
[TD="align: right"]£20,000[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]£2,531[/TD]
[TD]£2,449[/TD]
[TD]£2,531[/TD]
[TD]£2,531[/TD]
[TD]£2,449[/TD]
[TD]£2,531[/TD]
[TD]£2,449[/TD]
[TD]£2,531[/TD]
[TD="align: right"]20000[/TD]
[/TR]
[TR]
[TD]Contract 3[/TD]
[TD="align: right"]01/06/2019[/TD]
[TD="align: right"]31/12/2019[/TD]
[TD="align: right"]£30,000[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]£4,206[/TD]
[TD]£4,346[/TD]
[TD]£4,346[/TD]
[TD]£4,206[/TD]
[TD]£4,346[/TD]
[TD]£4,206[/TD]
[TD]£4,346[/TD]
[TD="align: right"]30000[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 3"]WHAT I NEED IT TO BE [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]Start Date[/TD]
[TD]End Date[/TD]
[TD]Revenue[/TD]
[TD]Jan-19[/TD]
[TD]Feb-19[/TD]
[TD]Mar-19[/TD]
[TD]Apr-19[/TD]
[TD]May-19[/TD]
[TD]Jun-19[/TD]
[TD]Jul-19[/TD]
[TD]Aug-19[/TD]
[TD]Sep-19[/TD]
[TD]Oct-19[/TD]
[TD]Nov-19[/TD]
[TD]Dec-19[/TD]
[TD]Total[/TD]
[/TR]
[TR]
[TD]Contract 1[/TD]
[TD="align: right"]01/04/2019[/TD]
[TD="align: right"]31/12/2019[/TD]
[TD="align: right"]£10,000[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]£10,000[/TD]
[TD="align: right"]£10,000[/TD]
[TD="align: right"]£10,000[/TD]
[TD="align: right"]£10,000[/TD]
[TD="align: right"]£10,000[/TD]
[TD="align: right"]£10,000[/TD]
[TD="align: right"]£10,000[/TD]
[TD="align: right"]£10,000[/TD]
[TD="align: right"]£10,000[/TD]
[TD="align: right"]90000[/TD]
[/TR]
[TR]
[TD]Contract 2[/TD]
[TD="align: right"]01/05/2019[/TD]
[TD="align: right"]31/12/2019[/TD]
[TD="align: right"]£20,000[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]£20,000[/TD]
[TD="align: right"]£20,000[/TD]
[TD="align: right"]£20,000[/TD]
[TD="align: right"]£20,000[/TD]
[TD="align: right"]£20,000[/TD]
[TD="align: right"]£20,000[/TD]
[TD="align: right"]£20,000[/TD]
[TD="align: right"]£20,000[/TD]
[TD="align: right"]160000[/TD]
[/TR]
[TR]
[TD]Contract 3[/TD]
[TD="align: right"]01/06/2019[/TD]
[TD="align: right"]31/12/2019[/TD]
[TD="align: right"]£30,000[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]£30,000[/TD]
[TD="align: right"]£30,000[/TD]
[TD="align: right"]£30,000[/TD]
[TD="align: right"]£30,000[/TD]
[TD="align: right"]£30,000[/TD]
[TD="align: right"]£30,000[/TD]
[TD="align: right"]£30,000[/TD]
[TD="align: right"]210000[/TD]
[/TR]
</tbody>[/TABLE]

 

[mrshl9898]

How about in E2?

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