On Tue, 5 Jan 2010 06:53:01 -0800, nginhong
wrote:

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

Read HELP for the WEEKNUM function, and you may understand that it does not
return a result according to the ISO standard.
--ron