WEEKNUM function


Returns the week number in the year.



=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.