So I have spent about 4 hours trying different combinations to get the result I am after.

I have a spreadsheet that automatically fills data from a separate CSV generated daily (data is added on to end on a day by day basis)

Column A is the Date, Column B is the values I want to average

Tried a variety of formulas but this is where my head was when I started

=AVERAGEIFS(B:B,A:A,(TODAY()-183),WEEKDAY(A:A),7)

I assume SUMPRODUCT would be the method to use but I haven't wrapped my head around that yet