COUNTIF date is in previous week

[surkdidat]

How do I compose a formula that looks at values in column BP that are from the previous week (The week always starts on a Monday. So for today,(being 4 December) I want it to count anything from Monday 26 November to Sunday 2 December inclusive please. On a Monday it needs to automatically change for the prev. week. So on Monday 10 Dec, it will automatically change the data to Mon 3 Dec-Sun 9 Dec.

 

[BarryL]

Hi, Column BP are dates correct?

I think the below will suffice.

=COUNTIFS(BP:BP,">="&(TODAY()-7)-MOD((TODAY()-7)-2,7),BP:BP,"<="&TODAY()-7+(7-WEEKDAY(TODAY()-7,2)))