|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
January 5th, 2010, 02:53 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 
|
|
#2
January 5th, 2010, 03:11 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
|
|
#3
January 5th, 2010, 03:16 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
|
|
#4
January 5th, 2010, 03:18 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
|
|
#5
January 6th, 2010, 01:23 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
