WEEKNUM ^v2.6.131 ​

Returns the week number of a given date based on a specified type of week.

WEEKNUM(date, return_type)

WEEKNUM(date, return_type)

Parameters ​

• date - The date to return the week number for, represented as an Excel date value.
• return_type - An optional argument specifying the type of week numbering system to use. See Excel docs for more return types. (optional)

Examples ​

WEEKNUM(44197)

WEEKNUM(44197)

Result: 1

Note: Returns the week number for January 1, 2021, using the default week numbering system that starts on Sunday.

WEEKNUM("2022-04-17", 2)

WEEKNUM("2022-04-17", 2)

Result: 16

Note: Returns the week number for April 17, 2022, using the ISO week numbering system that starts on Monday.