Hi Ngin Hong

See
http://www.rondebruin.nl/weeknumber.htm

Or
http://msdn.microsoft.com/en-us/library/bb277364.aspx


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"nginhong" wrote in message ...
Dear all,

Happy New Year!

I am using the following formula to show week number
="WEEK " & WEEKNUM(NOW(),1)

However I notice today 4th January 2010 turns out to be WEEK 2 and the
correct WEEK number should be 1 instead.

Do you think there is something wrong with the formula?
Also how to show correct week number from a date like 4th January 2010 is
equal to W101 or 10W1?

Your support is greatly appreciated.

Kind regards,
Ngin Hong