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.

Skillshare’s usually $10 a month, but because you’re an OfficeTuts reader you can get your first month free by clicking here. That’s unlimited access to over 18,000 classes on Excel, VBA, and much more.