Require Formula To Calculate Rolling Average For Each Week, Data With Multiple Years

[JP24357s]

Hi! I have a problem coming up with an accurate formula to calculate the rolling weekly average in my data set. For example, the average needs to be calculated for Monday, Monday and Tuesday, Monday Tuesday Wednesday, etc. The problem is I need this for each Weeknum() and Year() as there are multiple years of data in my data set.

Right now, I'm manually adjusting the formula in G2 for each new day added to the list. If this can be automated, it would be much easier to leave in the hands of someone else. In the attachment, most of the data in G is pulled and copied into cells rather than calculated (still building spreadsheet from convoluted old one).

Thank-you!

JP

[José Augusto]

Try this in G2 and copy down

Please Login or Register  to view this content.

[JP24357s]

Wow. Thank you very much! This seems to work perfectly and found a couple calculation errors done previously from the old spreadsheet. I appreciate the help!

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.