I could use some help with a formula for a workbook I use at work. The workbook has a sheet for every week with a few summary sheets in between for each month.
I have one sheet that shows the average for the whole year that looks like this
=AVERAGE('January 1st - January 5th:January 27th - February 2'!C4,'February 3rd - February 9th :February 24th - March 2rd'!C4,'March 3th - March 9th:March 31st - April 6th'!C4,'April 7th - April 13th:April 28th - May4th'!C4,'May 5th- May 11th:May 26th - June 1st'!C4,'June 2nd - June 8th :June 30th - July 6th'!C4,'July 7th - July 13th:July 28th - August 3th'!C4,'August 4th - August 10th:August 25th - August 31st'!C4,'September 1st - September 7th:September 29th - October 5th'!C4,'October 6th - October 12th:October 27th - November 2nd'!C4,'November 3rd - November 9th:November 24th - November 30th'!C4,'December 1st - December 7th:December 29th - January 4th'!C4)
How would I go about doing a 5 week average for that same cell with the most recent data? I'm thinking it would be something using OFFSET and COUNTA but I'm kind of just lost and throwing together things that come up on google. Also if there is a simpler way do the above average I'm all ears.