How can I calculate the number of the week based on a date in a list? I tried several examples I found on the internet, but none worked correctly?
The formula should comply with the ISO standard where the week always begins on a Monday, and ISO week 1 begins on the Monday of the first week of the year that contains a Thursday. Said differently, ISO week 1 is the first week (beginning on Monday) that has at least four days.
Anybody has a good solution for that?