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.




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

Leave a Reply

XLOOKUP Function in Excel

XLOOKUP replaces VLOOKUP AND HLOOKUP permanently! Speed up your spreadsheet by changing your default lookup function. Add a 4th and 5th argument!

Read More »
Scroll to Top