week

[bernardomarques]

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.

[Phil_Seamark · Accepted solution]

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)

[Aron_Moore]

Seems you've found a bug. I tested and got the same results. Also tried FORMAT and got the right number. Odd stuff