The internet, or at least the websites you’d go to for answers if you Googled something, don’t count the first incomplete week of the year when figuring week numbers.
Assume that for this discussion, Sunday is the start of the week
- Let’s work with the date: Sunday July 11th, 2021
It seems that the internet doesn’t count the first incomplete week of the year
Every webpage that I’ve gone to tells me that the week number for July 11th, 2021 is 28.
Check for yourself:
0 voters
I think defining which is first week of the year and so on is based on standards followed by different countries.
Most of Europe follows ISO standard week numbers and USA , Canada and some other countries follow a different system, a week starting on 1st January as first week.
It turns out something similar to date formats followed in different countries (mm/dd or dd/mm)
I think Google Sheets WEEKNUM() allows both options - ISO as well as the one followed by US.
https://support.google.com/docs/answer/3294949?hl=en
The articles below describe these week numbering systems.
https://www.calendar-12.com/week_number
Below are two interesting post threads on Weeknumbers. @Aleksi has suggested an interesting solution in one of the threads.