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.