Forum Discussion
Solved
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 option...
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)
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)