| Home |
| Search |
| Today's Posts |
|
|
|
#1
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert regular Date to Week Ending or Week Beginning Dates | Excel Discussion (Misc queries) | |||
| Is 4th January 2010 = Week 2?? | Excel Discussion (Misc queries) | |||
| 2010-01-04 is equal to week 2??? | Excel Discussion (Misc queries) | |||
| Return day of week for 1 January | Excel Worksheet Functions | |||
| Return the day of week for 1 January | About this forum | |||
Hybrid Mode
