Weekly Rolling Averages?!?!

Hello,

I work for a business and I keep and update daily statistics for our supply and demand. Currently I have a list by days of the week with a drop down list that I can view all Mondays or Tuesdays or any other days and take averages. I would like to automatically generate all of this because it has become a bear to go through every day and do averages manually.

I am looking for a rolling weekly average of 5 weeks and 10 weeks but how my data is set up makes that a little difficult.

A B
Monday 397
Tuesday 300
Wednesday 400
Thursday 280
Friday 300
Saturday 200
Sunday 86
Monday 280
... ...
... ...

I would like to create a rolling average of every day of the week but I can't seem to figure out how to separate each day of the week when they are all in 1 column.

I want a

A B C
Monday 5 Week Rolling Avg 10 Week Rolling Avg
Tuesday 5 Week Rolling Avg 10 Week Rolling Avg
Wednesday 5 Week Rolling Avg 10 Week Rolling Avg

Can anyone help?

Please upload sample data in a sheet.

Copy.xlsx

Does this attachment work?

That's just a sample I have data from 2011 to present in that format.