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/community/en-us/default.mspx?mid=c75660aa-7129-4fba-a6fd-4aa0ffc18c11&dg=microsoft.public.excel.worksheet.functions
0
Utf
1/25/2010 12:30:01 PM
excel.worksheet.functions 4936 articles. 2 followers. Follow

5 Replies
1169 Views

Similar Articles

[PageSpeed] 6

Isn't Jan 3rd week 53 of 2009?



"Paul Janssen" wrote:

> 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/community/en-us/default.mspx?mid=c75660aa-7129-4fba-a6fd-4aa0ffc18c11&dg=microsoft.public.excel.worksheet.functions
0
Utf
1/25/2010 12:46:01 PM
From E2007 help

 Important    The WEEKNUM function considers the week containing January 1 
to be the first week of the year. However, there is a European standard that 
defines the first week as the one with the majority of days (four or more) 
falling in the new year. This means that for years in which there are three 
days or less in the first week of January, the WEEKNUM function returns week 
numbers that are incorrect according to the European standard.


-- 
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that 
introduces the fewest assumptions while still sufficiently answering the 
question.


"Paul Janssen" wrote:

> 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/community/en-us/default.mspx?mid=c75660aa-7129-4fba-a6fd-4aa0ffc18c11&dg=microsoft.public.excel.worksheet.functions
0
Utf
1/25/2010 12:56:01 PM
It is not correct to describe Excel's output as "faulty".  It follows the 
not-unreasonable convention that puts January 1st in week 1.
The algorithm is shown in 
http://office.microsoft.com/en-gb/excel/HP052093371033.aspx, and there is a 
clear warning that other people may use different conventions. You will find 
some of those alternative conventions outlined at 
http://en.wikipedia.org/wiki/Seven-day_week#Week_numbering.
There is plenty of published information on alternative strategies for week 
numbers in Excel, including at http://www.rondebruin.nl/weeknumber.htm and 
at http://www.cpearson.com/Excel/WeekNumbers.aspx
--
David Biddulph

"Paul Janssen" <Paul Janssen@discussions.microsoft.com> wrote in message 
news:C75660AA-7129-4FBA-A6FD-4AA0FFC18C11@microsoft.com...
> 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/community/en-us/default.mspx?mid=c75660aa-7129-4fba-a6fd-4aa0ffc18c11&dg=microsoft.public.excel.worksheet.functions 


0
David
1/25/2010 12:56:33 PM
On Mon, 25 Jan 2010 04:30:01 -0800, Paul Janssen <Paul
Janssen@discussions.microsoft.com> wrote:

>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
>

Paul,

It really depends on how you define weeknumber.

The Excel WEEKNUM function behaves exactly as documented in HELP. "The WEEKNUM
function considers the week containing January 1 to be the first week of the
year."

And you can choose whether your week should start on Sunday or Monday.  If you
want your weeks to start on Monday, then enter the appropriate return argument
into the function and Jan 3, 2010 will fall into Week 1, giving you the results
you apparently desire.

I will also point out that there is an ISO standard for weeknumbers, which I'm
told is used extensively in Europe.  However, that standard would not return
week 1 for 2010-Jan-3 through 2010-Jan-9 as that standard calls for weeks to
start on Monday; and 2010-Jan-3 is a Sunday (and so would be week 53 under that
standard).
--ron
0
Ron
1/25/2010 1:54:43 PM
On Mon, 25 Jan 2010 08:54:43 -0500, Ron Rosenfeld
<ronrosenfeld@nospam.org> wrote:

>On Mon, 25 Jan 2010 04:30:01 -0800, Paul Janssen <Paul
>Janssen@discussions.microsoft.com> wrote:
>
>>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
>>
>
>Paul,
>
>It really depends on how you define weeknumber.
>
>The Excel WEEKNUM function behaves exactly as documented in HELP. "The WEEKNUM
>function considers the week containing January 1 to be the first week of the
>year."
>
>And you can choose whether your week should start on Sunday or Monday.  If you
>want your weeks to start on Monday, then enter the appropriate return argument
>into the function and Jan 3, 2010 will fall into Week 1, giving you the results
>you apparently desire.
>
>I will also point out that there is an ISO standard for weeknumbers, which I'm
>told is used extensively in Europe.  However, that standard would not return
>week 1 for 2010-Jan-3 through 2010-Jan-9 as that standard calls for weeks to
>start on Monday; and 2010-Jan-3 is a Sunday (and so would be week 53 under that
>standard).
>--ron

  I find it annoying that in a year that has always been only 52 weeks
long, that a standards organization would adopt a "standard" where a
"week 53" gets utilized.  It just caused an issue on our production floor
two weeks ago with respect to date coding for product serialization
purposes, which is where the entire system was derived from to begin
with.

  So what did those *they* people arrive at 5 decades ago?  I am quite
sure there will be a mil standard somewhere.  Regardless of what day of
the week it is or how it makes one's calendar appear to the eye, the week
that contains 1 January should be called "week 1".  The week that
contains the last 5 days of December should be called "week 52".  It does
not get much more simple than that.

 Worrying about the fact that we print a calendar with the same day at
the left edge of the grid has only muddied the fact.  Numbered weeks in a
year do not have a set "first day of the week"  Week numbering is a
function of the number 7 and the number 365.

  That is the US std (or was).  I too remember reading about the
variances and alternate "conventions" being utilized, however.

  The dude could make a custom "WEEKNUM_EU()" function.  :-)
0
CellShocked
1/27/2010 1:53:58 AM
Reply:

Similar Artilces:

Purpose of medium shade unicode character in Word 2010 equation ed
I tried asking about this before but I really wasn't specific enough. Please see the screen shot url below: http://lh3.ggpht.com/_4Fz7Um3aXFY/S6kQVJpdZwI/AAAAAAAAARU/1T14idbS1Is/s800/equation1.JPG The Unicode medium shade character in the Microsoft Word 2010 Equation Editor seems to have the effect of making the integral sign larger. I am sure there is more going on than just that, but I am not sure what. Is there a more specialized place where I can post this question. Thank you, LynchburgRecord You could try posting your question as a comment on Murray Sargent...

Installing Visual Studio Express 2010 and SQL Express R2
Hi, I tried to install Visual Studio Express 2010 (VB, C#, C++, and Web Develloper), and in the installation it need to install SQL EXPRESS (x64), but it always end up with that it is unable to install SQL EXPRESS So I downloaded the installation from the EXPRESS website, for both x86 and x64, and neither can install when they install the SETUP FILES I get an error The following error has occurred: Could not open key: UNKNOWN\Components\43C313DB6EBAD154F901C6B5BFA69F06\C2BF01D69A282F04190DB76EC40FAD2F. Verify that you have sufficient access to that key, or contact your ...

the office 2010 beta has the Portuguese dictionary?
the office 2010 beta has the Portuguese language but do not have the dictionary! if there! Where can I go get the dictionary? ...

incorrect audio track length returned from MCIWndGetLength for mp3
hi there i am using the MCIWnd* (ie Video for Windows) apis to play mp3 and wave files the MCIWndGetLength() macro is meant to return the length of the audio file, in milliseconds (to make sure this happens i call MCIWndUseTime() first) this works fine for WAV files, but the values returned for MP3 files don't reflect their duration in millisecs - what does it return for mp3 files? can i translate that easily into millisecs? tia bhu "bhu Boue vidya" <bhuvidya@yahoo.com.au> wrote in message news:1154303075.383266.204890@m79g2000cwm.googlegroups.com... > > the M...

DPM 2010 Eval
Can I install DPM 2010 Eval today and active it when I get my MSDN products keys? Yes, this is supported. Please check upgrade advisor http://blogs.technet.com/dpm/archive/2010/02/26/upgrade-advisor-for-dpm-2010-now-available.aspx for exact steps on how to upgrade from DPM 2010 Eval to Retail. -- Thanks Venkata Praveen[MSFT] This posting is provided "AS IS" with no warranties, and confers no rights. "tom" <user@msgroups.net/> wrote in message news:%23NNmSqJ6KHA.1424@TK2MSFTNGP04.phx.gbl... > Can I install DPM 2010 Eval today and active it wh...

ACH file incorrect
The bank says our ach file is incorrect. It should begin with 522 and end with 822 and it begins with 520 and ends with 820. Does anyone know where or what I need to change to get this the file to display correctly. Thanks for any input Brandon ...

DPM 2010 Reports better?
In DPM 2010, is the reporting any better? From what I recall from my DPM 2007SP1 testing the reporting was... lacking. It wasn't terribly detailed. I know there were ways to create new reports but I was never terribly gifted with SQL. It's been about 3 or 4 months since I last looked at it and I was just wondering if any changes in 2010. We have a new report to check for Recovery point status in DPM 2010. Any feedback on that? "NH2" <NH2@discussions.microsoft.com> wrote in message news:0DC28D61-0450-4ED8-BB7C-847753202824@microsoft.com... > In...

Where can I delete an old/incorrect email address?
I'm using Outlook 2003 So I have, say, Sandy in my contacts book. Her email is SW@...... Later her email changes to SAW@...... I make the change in my contacts. But when I'm creating a new email and I start to type "Sandy..." in the TO field, it still finds the old "SW@..." address. Why? How can I delete that old & incorrect address forever? (Without starting from scratch and loosing all my old email?) Thanks Gary use arrow keys to highlight 'bad' address then hit delete btn "jabadoodle" <jabadoodle@yahoo.com> wrote in message n...

Purchasing Dist Amount is Incorrect and will not post
Entering a PO Return. Select PO, receipt and Item. No problem. Click on distributions and the amount and accounts are correct (inventory account as purchase and accrual as accrual). Amounts are correct. Click save on distributions and receive error in subject line. Will not post. If you click on default, it clears out the distributions. If you then post, it'll post the return BUT SEND NOTHING TO THE GL! Of course, nothing was found on customersource's knowledge base (love what our $50,000 enhancement a year is for). We have one accrual account that is setup at setup > P...

Office 2010 retail
2 questions 1. Office used DOCx by default. Many users have older ver that only reads DOC. How can I change the default to DOC? 2. Line spacong by default is greater than 1 normal space. How can I change the default to the second line spacing option from the ribbon? -- Art Artsr3;1777323 Wrote: > 2 questions > 1. Office used DOCx by default. Many users have older ver that only > reads > DOC. How can I change the default to DOC? > > 2. Line spacong by default is greater than 1 normal space. How can I > change > the default to the second l...

embedding font problem in word 2007/2010
Hi The company I work for uses a non standard Font. When I embed the font in Word 2007 or 2010 (docx) I have two problems: 1. If you send the document to a person that doesnt have the font and hava a older word version the font will be replaced. so if I save the file in 2010 and open it in 2007 or 2003 on a machine that doesnt have the font it will be replaced even if the font is true type and embedable. If I save the document in 2010 or 2007 and uses the old fileformat (.doc) the font is correctly embedded. 2. the filesize increses for example from 166 kb (not embedded) to ...

The parameter is incorrect
Hi, I have a problem with OWA 5.5 SP4. This server is behind a proxy server 2.0. When I edit a new mail, go to options or attachments and I back to messages, the top buttons are not displayed. somebody help me??? Thanks. ...

exchange 2010 disk recommendation
Hi all, We have f/C SAN storage. We have exchange 2003 now with around 800GB data with RAID 5, lo on RAID 10, 9 mailbox stores, around 680 users, online mode. (no any limit set up here as it's not allowed. We are going to move to Exchange 2010. Will it still recommended that DATA and log on RAID10? or use RAID 5 for data and RAID 10 for LOG? Thank you. On Tue, 16 Feb 2010 07:00:01 -0800, ed <ed@discussions.microsoft.com> wrote: >Hi all, > >We have f/C SAN storage. We have exchange 2003 now with around 800GB data >with RAID 5, lo on RAID 10, 9 ...

How to Convert 24/03/2010 as text into 03/24/2010 date format
Hi , I’m using Ms Excel 2003 and in my excel sheet there is a column in which dates are entered as DD/MM/YYYY (e.g. 24/03/2010 as a text) format and I wanted to convert it into MM/DD/YYYY (e.g. 03/24/2010). Can excel programming is required to convert such date or is there any excel function. Please suggest. -- ------------------------------ Thanks Nitesh ------------------------------ hi you could use text to columns high light the date. on the menu bar>data>text to columns step 1 - select delimited, click next step 2 - select tab, click next step 3- upp...

Incorrect Balance Amount on Account List Page
The account list page shows the balance of one of my credit card's incorrectly. If however, I click on the credit card account, it shows the correct amount owed. Also, if I sort by unreconciled transactions, it shows the incorrect amount listed on the account list page. I tried reconciling all of these charges but still get the incorrect amount. Has anyone seen this before? In microsoft.public.money, James wrote: >The account list page shows the balance of one of my credit card's >incorrectly. If however, I click on the credit card account, it shows the >correct amoun...

0DAY PACK 2010.07.04.exe (7/7)
=ybegin part=7 line=128 size=1593944 name=0DAY PACK 2010.07.04.exe =ypart begin=1497601 end=1593944 �C[=@a=}�/��`�5Ҵ�b��,�'���r�?������/��3NV���q���w�3x��`A���7,$D2=J_SOfu�4p�"��Z&N�褜#-n���̷�@��r�/��5�QҬу��� I͠)?{7@�%��[�ym�z��^�~�:���ڑYdkŝ��� Dx���@3��8�p+�"y��$E�ޓeْ2�b<=}STTY]�=@T9W�6����P�%��C��^o�x+1��c�5[O|N�I�KD xb��1Œ�bz$Ӭk�#⺶H���C:��h��,E�?�\?���~��0볈�j�+���T���ay�$���Y%��-��5���<=}�i+�?O�7�#�m�%V�d��9Bc>Qv_;=}�V��w� ��&�S�F6����3���/;^�n�x��=J���>�$��H���WK�\�-�v�+:dyw�=J��A���n���J-����J�haak�]w���e��Z...

PPT 2010 truncates audio when saving as video
Hi I have Office 2010 beta and working in PPT 2010 I have an audio file from the clipart gallery in wav format that plays throughout the entire presentation. HOwever, when saving the file as a video, the sound is truncated after 2 loops which is about halfway through the second slide. The file is stored locally, have tried a different sound file, have tried compressing the media before converting. The audio is set to play beyond the duration of the presentation. ideas??? "laurie_g" <laurieg@discussions.microsoft.com> wrote in message news:21B359BC-5474-...

Outlook 2010 Quick Steps
On one of my computers Quick Steps will not let me save/add/edit email addresses. Any ideas? I've tried "repair". This was an install over 2007 on Win 7 64. My XP machine works fine. SoundMix wrote: > On one of my computers Quick Steps will not let me save/add/edit email > addresses. Any ideas? I've tried "repair". This was an install over > 2007 on > Win 7 64. > > My XP machine works fine. Can you save other quick steps, just not ones that contain email addresses? Larry the IT Guy -----------------------------...

Outlook 2010
In the little taskbar on the bottom - "Downloading Folder Order" keeps flashing, along with a little green progress bar. Does anyone have any idea what this is or how to stop it? "Excavator" <Excavator@discussions.microsoft.com> wrote in message news:DA3C836E-6526-4F03-8922-FC4BA0DAE885@microsoft.com... > In the little taskbar on the bottom - "Downloading Folder Order" keeps > flashing, along with a little green progress bar. > > Does anyone have any idea what this is or how to stop it? Ask Outlook 2010 questions in http://soc...

annualized return incorrect for transferred stocks
hello I transferred stocks from one account into another the problem is that the annualized return and return on all dates is calculated from the date for transfer rather than purchase. the cost basis/valuation figures are correct. is there any fix or work around for this? -thanks In microsoft.public.money, bill w <bill w@discussions.microsoft.com> wrote: >I transferred stocks from one account into another >the problem is that the annualized return and return on all dates >is calculated from the date for transfer rather than purchase. >the cost basis/valuation figures ar...

Exchange 2010 Mailbox access auditing
Hi, I was wondering where the mailbox access auditing log settings can be found on exchange 2010 servers ?!? On exchange 2007 sp2 servers there were the following loglevel settings: MSExchangeIS\9000 Private\Folder Access MSExchangeIS\9000 Private\Message Access MSExchangeIS\9000 Private\Extended Send As MSExchangeIS\9000 Private\Extended Send On Behalf Of Thanks Mario Mario;98153 Wrote: > Hi, > > I was wondering where the mailbox access auditing log settings can be > found > on exchange 2010 servers ?!? > > On exchange 2007 sp2 servers th...

Query Result Incorrect
I have a query based on a membership table in which I need to pull out all the people who do not have an email address. When I design the query and put "is null" in the criteria field for email address, it still returns names with email addresses. How can I get this query to pull out only the members who do not have an email address? Well what do you have in the columns with no email address? You should have a null but its possible your code puts either an empty string or a space in there. Since an email address should contain an '@' character you could try WHE...

URGENT-i entered an incorrect doct date in A/P, cannot fix it.
Hey, i found out i entered an incorrect doc date after i had already post the inoice(batch is still not update). then i went to "edit trx", they let me change anything except for the "trx date" is there anyone can help me with this? Thank you very much. We just started using this new software.................. Void and re-enter the invoice with the correct date. Best regards, -- MG.- Mariano Gomez, MIS, MCP, PMP Maximum Global Business, LLC http://www.maximumglobalbusiness.com "zhaoyue84@gmail.com" wrote: > Hey, > > i found out i entered an inc...

Free Kaspersky 2010 Lifetime Hack tutorial---with screenshot
http://hotfile.com/dl/20854705/e008a6d/Kaspersky_2010_Lifetime_Hack.rar.htm= l Note: you got yourself an genuine 30 days key given by the kaspersky servers itself What after the key gets blacklisted ?? This key will never get blacklisted coz this is very genuine What after 30 days are complete ???? Nothing! Just click on Activate beta license and click on =93Next.=94 That=92s it. The kaspersky server will give u a new 30 days genuine key. ...

Connection to the DPM service has been lost
I have 2 servers with a shared library. I just swapped out the tapes and upon performing a detailed or fast inventory, I get the Connection has been lost message. Events logs show the following error. The description for Event ID 943 from source MSDPM cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer. If the event originated on another computer, the display information had to be saved with the event. The following information ...