On Sat, 30 Jan 2010 13:11:02 -0800, ctante
wrote:

I am trying to build a rolling spreadsheet based on days. I want to have a
total for the trailing 30 days, but keep all the information that is older
than 30 days. If I lock the formula, and add new days it keeps the original
30 day calculation, instead of adding on 1 new day and dropping off the
oldest day of the 30.


Please give some more information about the layout of your
spreadsheet.
Is there one row per day, or one column per day?
Do you have data for every day, or can there be gaps in the dates?
If there are gaps, what do you mean by trailing 30 days?
Is it the 30 last dates, or all dates higher than the highest date
minus 30 days?

Lars-Åke