I have the following problem: I'm comparing daily statistics with prior
year but would like to do this on a month-to-date basis. This means
that I have to change the SUM range every-day for the current and prior
year in order to show the month-to-date total.
Can somebody tell me if there's a way to define the range in a way that
it will automatically increment as the days go by? The structure of my
table is somethink like this:

Days 1 2 3 4 5 6 ... Total to-date
Stats 5 8 10 3 26
Stats prior year 6 9 11 2 8 7 28

Many thanks for any help.