I have a spreadsheet that currently allows me to lookup historic returns based on a starting date (historic) forward (current). I want to modify that with cell K4 and have a date range of any month(s) within the spreadsheet (example is 01-01-2012 through 07-01-2012) that would change the investment value accordingly. In addition to that I want to see if its possible to have a graph that would graph that date range for the investor returns similar to that of the Total Fund Performance graph that is dynamic and changes with the date range.
I attached the spreadsheet. Any help would be very much appreciated.
Bookmarks