Hope someone can help

I get a file of data every week that contains info on the 7 days in that week. There is a column that specifies the date next to all of the other responses.

At the moment, to work out the average of a set of responses for each day I have to use the filters

Is there any formula that I can use which would automatically seperate data based on dates?

For the other columns I use a combination of macro's and cell formula but of course the dates change every week so not sure how to do this

Any help appreciated