# Recurring Revenue between two dates

#### EmSav

##### New Member
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>

### Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

#### mrshl9898

##### Well-known Member

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

Last edited:

Replies
2
Views
76
Replies
3
Views
94
Replies
3
Views
45
Replies
12
Views
136
Replies
16
Views
135