WEEKNUM

Get the week number for a given date

Sponsored Link

WEEKNUM

Purpose 

Get the week number for a given date

Return value 

A number between 1 and 54.

Syntax 

=WEEKNUM (serial_num, [return_type])

Arguments 

  • serial_num - A valid Excel date in serial number format.
  • return_type - [optional] The day the week begins. Default is 1.

Usage notes 

The WEEKNUM function starts counting with the week that contains January 1. Thereturn_type argument is optional and defaults to 1. Return_type can either be 1 or 2:

1 - Week begins on Sunday 
2 - Week begins on Monday

Sponsored Link

0 votes. 0 / 5