Learn How to Use Microsoft Excel WEEKNUM Function

Microsoft Excel WEEKNUM Function

The prime purpose of the WEEKNUM function is to get a week number for a specified date. So with the help of the Microsoft Excel WEEKNUM function, you can take a particular date and get a return value from 1 to 54, representing weeks in a year. The WEEKNUM function starts counting the week starting from January 1, and by default, the first starts from Sunday.

WEEKNUM Function Return Value

The return value will be the number between 1 to 54.

WEEKNUM Function Syntax

= WEEKNUM(serial-number, [return-type])

Where:

• serial-number: It is a valid Excel date in a serial number format.
• return-type: It is a day from when the week begins, and the default is 1 (optional).

How to Use Microsoft Excel WEEKNUM Function?

The WEEKNUM function will begin counting with the week, which having January 1. With the return-type argument, you can control which day of the week you should use to start the new week number. Here the return-type is optional and has the default value 1.

 By using the return-type from 1-17, the week number is 1 in a given year is assigned to the week that is having January 1. With return-type 21, week one is the week having the first Thursday of the year. This is all as per the ISO 8601 rules.

Check out the list of all other articles:

• Learn How to Use Microsoft Excel WORKDAY Function
• Learn How to Use Microsoft Excel SECOND Function
• Learn How to Use Microsoft Excel NOT Function
• Learn How to Use Microsoft Excel AND Function