Why does weeknum not work

However, for this year. Regardless if you use the standard format or the ISO then this entire week would be week 1 as this week has 5 or 6 days of the new year in it depending on if you set the week to start on Sunday or Monday. Message 3 of In response to HellishFarva. Hi HellishFarva , I confirmed internally, the results you got is expected, the weeknum function works fine.

Message 5 of Message 7 of Regards, Michael. Message 8 of Hi, I agree there is a bug in this! How can we fix this Thanks Andrew. Message 6 of Hi HellishFarva , I have consulted this issue internally, will update here once I get information. Message 4 of Post Reply. Helpful resources. Launching new user group features Learn how to create your own user groups today!

Learn More. The Countdown is on! Sign up now for the year's largest virtual gathering of Microsoft data platform professionals. As they have - correctly - saved the spreadsheet as "week 27", it didn't work. I initially assumed that the accounts team were wrong, but I checked online and they are correct. I know that there is an issue with Excel not following ISO standards for when weeks 53 and 1 begin and end, but I don't see how that could affect a mid-year week. It did occur to me that the issue might be to do with UK versus US date formatting.

But, of course, the 7th of June wasn't in week 28 either. System 1 The week containing January 1 is the first week of the year, and is numbered week 1. System 2 The week containing the first Thursday of the year is the first week of the year, and is numbered as week 1. This system is the methodology specified in ISO , which is commonly known as the European week numbering system.

How are we doing? Please help us improve Stack Overflow. Take our short survey. Stack Overflow for Teams — Collaborate and share knowledge with a private group.

Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Excel weeknum function returns wrong week Ask Question. Asked 5 years, 4 months ago. Active 4 years, 10 months ago. Viewed 19k times. If you forgot your password, you can reset your password.

JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding. You are using an out of date browser. It may not display this or other websites correctly.

You should upgrade or use an alternative browser. Thread starter tmd63 Start date Oct 23, Tags function reports week week number week numbers. Joined Feb 21, Messages It is still part of week The same happens in and Last edited: Oct 23, Excel Facts. Click here to reveal answer. It looks like it might handle it correctly if you use "21" instead of "11" in the second argument, i.

Hi, Nope. I thought of that and attempted to use the function with ALL variations from 1 to Thats weird. Its 53 on mine.