count dates that are within 7 days of another date/time

[enxxmp]

I need to count the date/times in the "Rebooted" column (d:d) that are within the last 7 days of the date/times in the "Timestamp" column (b:b). I've tried several countif fomulas but can't figure it out. Thanks.

STB S/N	Timestamp	Uptime	Rebooted
387968022144103323	4/13/2023 17:36:29	92	4/13/2023 17:34:57
387968022144103957	4/13/2023 17:36:24	61	4/13/2023 17:35:23
387968022054102467	4/13/2023 17:34:41	51	4/13/2023 17:33:50
387968022423104062	4/13/2023 17:33:43	1770988	3/24/2023 5:37:15
387968022415108804	4/13/2023 17:32:47	87	4/13/2023 17:31:20

 

[JamesCanale]

=SUM(--(B2:B6-D2:D6<=7))

 

[awoohaw]

deltee. i had an error