John Skolits
askolits at ot.com
Tue Jan 2 12:06:26 CST 2007
Last year I was using the following to get the week number: WorkWeek = Val(Format("1/2/06", "ww", vbMonday)) - 1 ) The work week for my customer started on a Monday I never really understood why I had to add the "minus one", but the first Monday and remaining week of 2006 would return a "2", so I just subtracted 1 and all was fine. But this year, there are 53 Mondays so this line of code returns a "0" for the first week of January. Is there another way I should be getting the work week number? John