Returns the ISO 8601 week number of the year for a given date.
この関数は Google スプレッドシートでも Excel と同じように機能します。構文も引数も同じです。
ISOWEEKNUM(date)The ISOWEEKNUM function calculates the week number based on the ISO 8601 standard, where the week starts on Monday and the first week of the year contains the first Thursday. This function is useful for international business reporting where a consistent weekly calendar is required.
=ISOWEEKNUM("2023-01-05")結果: 1
Returns 1 because January 5, 2023, falls in the first ISO week of the year.
ISOWEEKNUM strictly follows the ISO 8601 standard, while WEEKNUM allows for different return types to define which day the week starts on.