Excel WEEKNUM Function

Excel WEEKNUM Function

Summary 

The Excel WEEKNUM function takes a date and returns a week number (1-54) that corresponds to the week of year. The WEEKNUM function starts counting with the week that contains January 1. By default, weeks begin on Sunday. 

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

0 votes. 0 / 5

Excel - Excel Functions - Excel Formulas
Logo