WEEKNUM function

DESCRIPTION:

Returns the week number in the year.

 

SYNTAX:

=WEEKNUM( serial_number, [return_type] )

 

REQUIRED ARGUMENTS:

serial_number

A valid Excel date in serial number format.

 

OPTIONAL ARGUMENTS:

[return_type]

The day the week begins. The default is 1.