WEEKNUM Function

The WEEKNUM Function in Excel will return the week number for a specific date. This function will return an integer from 1 to 52 representing the corresponding week based on a standard calendar year.

Syntax:

=WEEKNUM(serial_number,[return_type])

Arguments:

  • Serial_number (required argument) – Excel date for which we want to return the week number.
  • Return_type (optional argument) – This specifies which numbering system should be used and which day of the week should be treated as the start of the week. See the chart below. Default in Sunday.
WEEKNUM Chart
This chart indicates what day starts a week in Excel.

Download Demo File

WEEKNUM Function Usage Example

In the example below, the function returns the week of each date. In all of the examples, we have the Return_Type set to 1. This means that each week starts are Sunday.

WEEKNUM Function