How to calculate weekly average in Excel

We have introduced the way to calculate averages per day/month/quarter/hour with pivot table in Excel before, but this method can't calculate the averages per week. Here I will introduce a way to calculate the weekly averages with a help columns in Excel easily. More details: https://www.extendoffice.com/document...