LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Weeknum in 2010 incorrect

Hello, we encountered a faulty weeknumber generated by MX Excel for all dates
in 2010 as of Jan 3d, 2010. This should be weeknumber 1 until January 9th,
2010 but MX Excel uses weeknumber 2. As a result all consecutive weeks in
2010 are numbered 1 week too high.

Would be nice if MS could issue a repair patch!

regards, Paul Janssen

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Is 4th January 2010 = Week 2?? nginhong Excel Discussion (Misc queries) 5 January 28th 10 09:42 AM
Office 2010 rosmie Excel Discussion (Misc queries) 1 January 8th 10 09:29 AM
2010 in Excel 2000 BudW Excel Discussion (Misc queries) 2 January 5th 10 03:47 PM
2010-01-04 is equal to week 2??? nginhong Excel Discussion (Misc queries) 1 January 4th 10 02:10 AM
World Cup 2010 Spreadsheet Originalgoth Excel Discussion (Misc queries) 1 December 23rd 09 03:39 PM


All times are GMT +1. The time now is 01:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"