Average if day is Monday and within last 6 months

Hi stiggz

Would it not be easier to have a helper column for the weekday of the dates in column A. Then you could use the AVERAGEIFS function. I have used column C>

Formula:

=AVERAGEIFS($B$2:$B$986,$A$2:$A$986,">="&TODAY()-183,$A$2:$A$986,"<"&TODAY(),$C$2:$C$986,"2")