Calculating average

[1234adam]

I am trying to write an expression that would give me the average of the eight prior weeks. But i only want to have it calculated on fridays. So i have started the expression with this =IIF(6=Weekday([Date]),I WANT THE AVG CALCULATED HERE," ")

Thanks for any help