Week numbers in Google Sheets

To calculate the ISO 8601 week number in Google Sheets, use the following formula:

* Ensure your system or application regional settings are set to follow ISO 8601 standards (weeks start on Monday) if the output varies.