If you are basing this from the current date 2017-10-16 and always will be, then simply take 7 days off the current date as your end date, and then a year off of that.
Something like;
Code:
Between DateAdd("yyyy",-1, DateAdd("d",-7,Date() ) ) And DateAdd("d",-7,Date())
If yuo want to specify the date used, substitute them where the Date() is in the above
The main issue is that nobody seems to realize that a week isn't a true base unit to years. They just don't fit.
1 week = 7 days
1 year = 365 days (about 75% of the time)
365/7 = 52.1428
That remainder always kills any comparisons you try to do week by week in differing years. Eventually they add up and you have to assign them to some year.