Need help with easier way to average data every 7th day of the week and from column header named "E" in the attached sample spreadsheet.
I have only shown dates from Jan 1 -7th, but spreadsheet will be for full calendar year, and formula will be in "data transfer" tab in sample file.
I can use simple average formula, but it's very time consuming. Any help is appreciated.