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:
<TBODY>
</TBODY>
Then a row with hard-coded expenditures:
<TBODY>
</TBODY>
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
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:
1-06-2012 | 01-01-2013 | 01-06-2013 | 01-01-2014 | 01-06-2014 | 01-01-2015 | 01-06-2015 | 01-01-2016 |
<TBODY>
</TBODY>
Then a row with hard-coded expenditures:
0 | 23 | 23 | 34 | 34 | 0 | 0 | 0 | 0 | 0 |
<TBODY>
</TBODY>
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