Formula to flag rolling weeks

[rfigueroa1976]

Is there a formula that would let me flag that last ten weeks from current date, taking into consideration that week 52 (sometimes 53) rolls back to week 1

For example.... Below is column A (The date) and B (the flag) I'd like the formula to look at the date in the cell and if the date in the cell is within 10 weeks from today's week number, flag as "Rolling 10", otherwise, leave blank... =if(weeknum(today()-weeknum(a1)<11. "Rolling 10", "") <-- obviously does not work. Your help will be greatly appreciated!



9/30/2018
10/7/2018
10/14/2018
10/21/2018
10/28/2018
11/4/2018 - "Rolling 10"
11/11/2018 - "Rolling 10"
11/18/2018 - "Rolling 10"
11/25/2018 - "Rolling 10"
12/2/2018 - "Rolling 10"
12/9/2018 - "Rolling 10"
12/16/2018 - "Rolling 10"
12/23/2018 - "Rolling 10"
12/30/2018 - "Rolling 10"
1/6/2019 - "Rolling 10"

 

[rfigueroa1976]

Update.... The flag is working when looking at the weeks but not taking year into consideration. I'm assuming it's looking at today's week number? Meaning, it's flagging the date 01/06/18, 01/06/17, 01/06/16 as within the rolling week count. Help please.