Hi,
I am trying to create a formula that will automatically average data from the last 7 days in a table based on whether or not it's a weekday or weekend. I have to update this on a weekly basis and want the template to pull the last 7 days without having to manually change the table array which is why I'm not just using an averageifs tied to the value in column a. I've attached an example file on what I'm working with.
I have tried a variation of different averageifs and offsets and while I can get some formulas to work, I cannot think of a way automatically select the last 7 days and get it to average based on whether or not it's a weekday or weekend. Essentially, I want the formula =average(offset(c1,counta(c1:c31)-7,0,7) to average based on weekdays vs weekends.
Any input would be greatly appreciated and thank you in advance!!
Bookmarks