Move numbers conditional on date

[DaanN]

Dear Mr Excel forum members,

I have the following issue: I have a row of expenditures that I want to start on a date that I can vary:
First I have a row with dates:

[TABLE="class: grid, width: 500"]
<TBODY>[TR]
[TD]1-06-2012[/TD]
[TD]01-01-2013[/TD]
[TD]01-06-2013[/TD]
[TD]01-01-2014[/TD]
[TD]01-06-2014[/TD]
[TD]01-01-2015[/TD]
[TD]01-06-2015[/TD]
[TD]01-01-2016[/TD]
[/TR]
</TBODY>[/TABLE]

Then a row with hard-coded expenditures:
[TABLE="class: grid, width: 500"]
<TBODY>[TR]
[TD]0[/TD]
[TD]23[/TD]
[TD]23[/TD]
[TD]34[/TD]
[TD]34[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
</TBODY>[/TABLE]

As you can see not each month there will be an expenditure. In a new row I want the same stream of expenditures but then starting in another month e.g. 01-06-2014. In the other months, I want 0 expenditure.

How could I create this new row that is linked to the hard-coded expenditures and to a cell where I enter the date they should start?

I would appreciate your ideas. Sincerely,
Daan

 

[DaanN]

Is the question unclear? Here is a small excerpt from the file

ExampleMRexcel.xlsx