WEEKNUM ^v2.6.131
Returns the week number of a given date based on a specified type of week.
js
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
js
WEEKNUM(44197)Result: 1
Note: Returns the week number for January 1, 2021, using the default week numbering system that starts on Sunday.
js
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.