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

WORKDAY Function

The WORKDAY function in Excel takes a date and returns the nearest working day. This is achieved based on user

Read More »

INT Function

The INT function in Excel rounds a number down to the nearest integer. This function will always round down. For

Read More »
Scroll to Top