BrettOlbrys1
Board Regular
- Joined
- May 1, 2018
- Messages
- 128
- Office Version
- 365
- Platform
- Windows
Based on a week date, I want to assign a "1" to that date. The dates greater than that date, I want the value to count up by +1 and the dates less than that date, I want them to count down by -1. My file is not static though because based on when the file is opened, the numbers assigned to the static dates will move. I need a formula that will assign the numbers above the dates.
If today was 4/19 | ||||||||||||||
-5 | -4 | -3 | -2 | -1 | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |
3/8 | 3/15 | 3/22 | 3/29 | 4/5 | 4/12 | 4/19 | 4/26 | 5/3 | 5/10 | 5/17 | 5/24 | 5/31 | 6/7 | 6/14 |
If today was 5/10 | ||||||||||||||
-8 | -7 | -6 | -5 | -4 | -3 | -2 | -1 | 0 | 1 | 2 | 3 | 4 | 5 | 6 |
3/8 | 3/15 | 3/22 | 3/29 | 4/5 | 4/12 | 4/19 | 4/26 | 5/3 | 5/10 | 5/17 | 5/24 | 5/31 | 6/7 | 6/14 |
If today was 5/24 | ||||||||||||||
-10 | -9 | -8 | -7 | -6 | -5 | -4 | -3 | -2 | -1 | 0 | 1 | 2 | 3 | 4 |
3/8 | 3/15 | 3/22 | 3/29 | 4/5 | 4/12 | 4/19 | 4/26 | 5/3 | 5/10 | 5/17 | 5/24 | 5/31 | 6/7 | 6/14 |