rfigueroa1976
New Member
- Joined
- Jan 10, 2019
- Messages
- 14
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"
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"