Is 4th January 2010 = Week 2??
 

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

Is 4th January 2010 = Week 2??
 

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

Is 4th January 2010 = Week 2??
 

See the answers when you asked the same question yesterday in another group.
Please don't multipost.
--
David Biddulph

"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

Is 4th January 2010 = Week 2??
 

See your discussion (thread) in Excel General Questions (m.p.excel).


----- original message -----

"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

Is 4th January 2010 = Week 2??
 

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