WEEKOFYEAR is not aligning to ISO-8601, is this correct?

@Samuel.

Have a look at using the function Week and pass into it whatever mode fits your needs.

WEEKOFYEAR(date[,mode])

WEEK(date[,mode])

Both do the same thing.

Modes are

0: First day is Sunday, range is 0-53, first week has a Sunday in this year.

1: First day is Monday, range is 0-53, first week has more than 3 days this year.

2: First day is Sunday, range is 1-53, first week has a Sunday in this year.

3: First day is Monday, range is 1-53, first week has more than 3 days this year.

4: First day is Sunday, range is 0-53, first week has more than 3 days this year.

5: First day is Monday, range is 0-53, first week has a Monday in this year.

6: First day is Sunday, range is 1-53, first week has more than 3 days this year.

7: First day is Monday, range is 1-53, first week has a Monday in this year.

https://domo-support.domo.com/s/article/360044289573?language=en_US