I looked at your xls yesterday - here's a little trick you might want to add
In B2, enter the ROW # of the day you're calculating. In C2 through L2, change each formula to this: =INDIRECT("C"&$B$2) - of course. you'll change that "C" to "D" for D2, "E" for E2 and so on.
That way, just...