Recurring Revenue between two dates

EmSav

New Member
Joined
May 21, 2018
Messages
1
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 DateEnd DateRevenueJan-19Feb-19Mar-19Apr-19May-19Jun-19Jul-19Aug-19Sep-19Oct-19Nov-19Dec-19Total
Contract 101/04/201931/12/2019£10,000 £1,091£1,127£1,091£1,127£1,127£1,091£1,127£1,091£1,12710000
Contract 201/05/201931/12/2019£20,000 £2,531£2,449£2,531£2,531£2,449£2,531£2,449£2,53120000
Contract 301/06/201931/12/2019£30,000 £4,206£4,346£4,346£4,206£4,346£4,206£4,34630000
WHAT I NEED IT TO BE
Start DateEnd DateRevenueJan-19Feb-19Mar-19Apr-19May-19Jun-19Jul-19Aug-19Sep-19Oct-19Nov-19Dec-19Total
Contract 101/04/201931/12/2019£10,000£10,000£10,000£10,000£10,000£10,000£10,000£10,000£10,000£10,00090000
Contract 201/05/201931/12/2019£20,000£20,000£20,000£20,000£20,000£20,000£20,000£20,000£20,000160000
Contract 301/06/201931/12/2019£30,000 £30,000£30,000£30,000£30,000£30,000£30,000£30,000210000

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

Some videos you may like

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
Joined
Feb 6, 2012
Messages
1,440
How about in E2?

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

Watch MrExcel Video

Forum statistics

Threads
1,109,518
Messages
5,529,309
Members
409,862
Latest member
lbisacca
Top