January 1, 2021 falls in ISO week 53 of 2020. Use the year of that week’s Thursday when building a year-week label.

Move from the date to its week’s Thursday

Put =DATE(2021,1,1) in A2 and use this in B2.

=YEAR(A2-WEEKDAY(A2,2)+4)&"-W"&TEXT(ISOWEEKNUM(A2),"00")

With Monday numbered 1, Thursday is 4. The calculation uses December 31 as the Thursday for January 1, and the label should be 2020-W53.

Friday January 1 shares a week with Thursday December 31.

Illustrated ISO year rule. The Thursday belongs to 2020.

Check the next Monday

Change A2 to January 4, 2021 and expect 2021-W01. Keep the original date for sorting individual records. Confirm the report uses ISO weeks before grouping the rows.

Monday January 4 starts 2021-W01.

Illustrated New Year check. Verify both sides of the transition.

Microsoft’s ISOWEEKNUM function reference