All functions / Date & Time
WEEKNUM
The week number of the year.
Syntax
=WEEKNUM(serial_number, [return_type])
Arguments
serial_number: A date (or a cell containing one).return_type(optional): 1 (default) or 17: weeks start Sunday. 2 or 11: Monday. 12–16: Tuesday to Saturday. 21: ISO weeks.