Count specific cell values if date of cell is within 7 days from now.

[SplatP1]

Hello,

I need a formula to count the number of times that there is a zero in a row next to a name, as long as the date of the column is less than 7 days ago.
Result in ColB.
Blank cells should be ignored.

Thanks in advance!
Owen

 

[BigBeachBananas]

Book2
	A	B	C	D	E	F	G
1	Name	Missed	10/6/23	10/4/23	10/2/23	9/28/23	9/26/23
2	John	1	0	52245	524	20888	13413
3	Sue	1	44109		0	0	0
4	David	2	44618	0	0	0	17702
5	Mary	0	31631	38191	2873	29574	16898
6
7
8	10/7/23
Sheet3

Cell Formulas
Range	Formula
B2:B5	B2	=SUM(--NOT(ISERR(FILTER(C2:G2,(C2:G2=0)*($A$8-$C$1:$G$1<=7)*NOT(ISBLANK(C2:G2))))))
A8	A8	=TODAY()

 

[SplatP1]

Thanks BBB, Works perfect!