Egad...what is this supposed to be doing?
If I am looking at this right, what this does is assign a Week number based on today's date. So based on today's date (3/25/14)
1/14/14 - 3
1/7/14 - 2
12/31/13 - 53
12/24/13 - 52
12/17/13 - 51
Since the Today() function is dynamic, the values returned will change. Next week...
1/14/14 - 4
1/7/14 - 3
12/31/13 - 2
12/24/13 - 53
12/17/13 - 52
What is it you are trying to do?
|