I hope I am not coming to the well too often but the help people provide
here is incredible.

I have a data sheet that will not be seen by users. They input data daily
using a form. Column A has the date and B and C have numbers associated
with that particular date.

Data is entered daily but may always not be in order. The users are not
able to sort the sheet. Since data are entered daily the number of rows of
data will continue to grow over time.

Can someone suggest a formula that will look through all the data and show
the average for the last 4 mondays? I will need to do the same for each day
of the week.

Thank you :)