Learn How to Use Microsoft Excel WEEKNUM Function
In this article, you will learn how to use the Microsoft Excel WEEKNUM function and its prime function in Microsoft Excel. You will also get to know the Microsoft Excel WEEKNUM function return value and syntax with the help of some examples.
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])
- 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: