Help finding 3 weeks ago's Saturday date formula

Hello!

I cannot find a way in Access to find today's date three weeks ago's Saturday's date.

For example, if today is 10/09/2019 I need to find 09/21/2019 using a formula.

Here is where I am stuck:

(Date()-(Weekday(Date()))*7)

This gave me four weeks ago and it was a Tuesday.

Thank you for your help!

Thanks. I will try your formula. But I must do it in access. That is the requirement I have been given.

I tested your formula and it did not work. It returned 9/30/2019. Thanks for your help.

I figure it using your approach. The formula is,

Date()-(21+Weekday(Date()))

Thanks