Number of week wrong

[Guest]

I am extracting some information from my database in week format.
I have done this in the normal way of using the Format function and W.
The week number it gives me is one ahead of actual week number in my diary.
Has anyone else come across this, or know how to fix it??

 

[Douglas J Steele]

There are a couple of optional parameters you can pass to the Format
function when you're using the "w" format to specify what should be treated
as the first day of the week, and what should be treated as the first week
of the year.


Check the help file, or see
http://msdn.microsoft.com/archive/en-us/office97/html/output/F1/d6/S5B22A.asp
(don't worry that it says Archived Content: it hasn't changed!)