View Single Post
 
Old 03-25-2014, 07:24 AM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

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?
Reply With Quote