Greetings,
I'm not sure I'm posting this in the right place, but thought I would try anyway.
I'm posting a trading spreadsheet here (see attached), and am wondering if anyone can help with adding dates to the spreadsheet? Specifically, what I am wanting to do is be able to change the "Starting Date" at any time, and then have the spreadsheet display the dates of the amounts calculated.
In other words, I want to be able to change the "Starting Date" to today's date, for example. Then, since the rows are weekly, four columns down should display the date 1 month from now. Eight rows down it should display 2 months from now. And so on.
Can anyone do this?
Thank you in advance if you can.
I'm not sure I'm posting this in the right place, but thought I would try anyway.
I'm posting a trading spreadsheet here (see attached), and am wondering if anyone can help with adding dates to the spreadsheet? Specifically, what I am wanting to do is be able to change the "Starting Date" at any time, and then have the spreadsheet display the dates of the amounts calculated.
In other words, I want to be able to change the "Starting Date" to today's date, for example. Then, since the rows are weekly, four columns down should display the date 1 month from now. Eight rows down it should display 2 months from now. And so on.
Can anyone do this?
Thank you in advance if you can.
Attached File(s)
Compounding Spreadsheet Started March 1 2011.xls
206 KB
|
340 downloads