The main area of my worksheet looks like the following (hopefully, my
formating carries through):

Today Week Month
Year
Actual | Budget | Actual | Budget | Actual | Budget |
Actual | Budget

My raw data is placed in the far right of the worksheet and looks like:
Budget for Each Day | Day1Actual | Day2Actual | Day3Actual ......

The "Actual" part of the worksheet are the day's results. For the Week,
Month, and Year, the result is the accumulation of all the daily results up
to that point. So, for example, on the 10th week and 6th day of the year,
the Year's Actual numbers would be the sum of the previous 9 weeks plus the 6
days, while the Week's numbers would just be the sum of the past 6 days.

At the moment, all of the fomulae in the main section of my worksheet must
be changed daily in order to pull the raw data from the right. Most of the
time, it is simply adding another columns data to the sum results. However,
for the beginning of each week and month, I need to start the data range all
over again. This is a huge worksheet with a lot of data in it.

Is there any way to make this procedure simplier? Is there anyway to have a
fomula that says, "This is the 245th day in the year, the 18th day in the
month, and the 4th day of the week. Now go pull the appropriate data from
the appropriate columns, do the summation of that data, and put it
Week:Actual column, the Month:Actual column, and the Year:Actual column." If
so, that would be great! But, honestly, if anyone out there has some
suggestions with this worksheet, it would be really apprieciated. I would
love to make it as automated as possible, but any shortcuts or time-saving
steps would be lovely.

Thank you for reading!