Forum Discussion
week
I'm using the native function "WEEKNUMBER" which should return the week number of a date in the year. However i realized that the returned number doesn't makes sense considering the two return options.
Example: Considering the day 02/11/2017, which belongs to week 44 of the year 2017 and its a thursday, the function WEEKNUMBER("02/11/2017";2) returns 45 as week number and WEEKNUMBER("02/11/2017";1) returns week 44. Both should return the same value as this day is a thurdsday, despite begining on monday (2) or on sunday (1). I'm I missing something?
Thank you in advance.
It's because the start of Calendar Year 2017 was a Sunday.
You'll see here, the 2nd column uses the "2" parameter and pushes the 2nd day of the year into week 2. While week 2 doesn't start until the 8th of Jan for the "1" parameter (the middle column)
2 Replies
Seems you've found a bug. I tested and got the same results. Also tried FORMAT and got the right number. Odd stuff
It's because the start of Calendar Year 2017 was a Sunday.
You'll see here, the 2nd column uses the "2" parameter and pushes the 2nd day of the year into week 2. While week 2 doesn't start until the 8th of Jan for the "1" parameter (the middle column)
