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.