I'm a rookie at making financial formulas on Excel 2007 so I need some help. I have made an investment worksheet to keep track of my annual rate of return each month on each account as I enter the monthly totals. I have a cash entry for each end of month statement of the year for each account. So for instance let's say I have all the end of month totals for each account listed for the year up to September 2011. I would like to know what my rate of return is thus far for the year to the end of September. As I add another month total I want the rate of return to change to demonstrate that change. Any help will be appreciated.