WEEKNUM
Returns the week number of a specific date
Syntax
WEEKNUM(serial_number, [return_type])
Parameters
- serial_number: Required. A date within the week
- return_type: Optional. A number that determines on which day the week begins (1=Sunday default, 2=Monday, 11-17 various)
Example
=WEEKNUM("1/15/2024", 1)