How to get the Saturday a week ago

Other SQL Server Topics
1

I have been trying several options and can only seem to get the prior Saturday a week ago the way below if it is 5/2/2023. If I were to run this 5/3/2023, I would need to change to -9. -8 or -9 gives me 4/23/2023. What I want is to always have the Saturday but as of a week ago without changing the -8 or -9 or - whatever depending on when I run this because I want to automate my stored procedure.

where [Review Completed Date] between '2022-01-01' and
DATEADD(wk, DATEDIFF(wk, -1, getdate()), -8)
order by [review completed date] desc

2 

SELECT DATEADD(DAY, -DATEDIFF(DAY, 5, GETDATE()) % 7 - 7, CAST(GETDATE() AS date))
3

To see other date results:


DECLARE @date date

SET @date = GETDATE()
SELECT @date, DATEADD(DAY, -DATEDIFF(DAY, 5, @date) % 7 - 7, CAST(@date AS date))

SET @date = DATEADD(DAY, 1, GETDATE())
SELECT @date, DATEADD(DAY, -DATEDIFF(DAY, 5, @date) % 7 - 7, CAST(@date AS date))

SET @date = DATEADD(DAY, 2, GETDATE())
SELECT @date, DATEADD(DAY, -DATEDIFF(DAY, 5, @date) % 7 - 7, CAST(@date AS date))

SET @date = DATEADD(DAY, 3, GETDATE())
SELECT @date, DATEADD(DAY, -DATEDIFF(DAY, 5, @date) % 7 - 7, CAST(@date AS date))

SET @date = DATEADD(DAY, 4, GETDATE())
SELECT @date, DATEADD(DAY, -DATEDIFF(DAY, 5, @date) % 7 - 7, CAST(@date AS date))