WEEKNUM function - The function returns the week number of the year in Excel

The following article introduces you to the WEEKNUM function - one of the functions in the date and time group function is very popular in Excel.

WEEKNUM function - The function returns the week number of the year in Excel Picture 1

Description: The function returns the ordinal number of the week of the year for the particular day within that week. There are 2 systems used in the function to determine the week number:

- System 1: The week with January 1 is the first week of the year and is numbered 1.

- System 2: The first Thursday of the year is the first week and is numbered 1. This system is called the methodology defined in ISO 8601 (European numbered week).

Syntax: WEEKNUM (serial_number, [return_type])

Inside:

- serial_number: The value of the day of the week to calculate the order of the week, is a required parameter.

- return_type: The return value of the function, is an optional parameter including the following values:

+ return_type = 1 or skip -> week starting on Sunday and numbered 1.

+ return_type = 2 -> week starts on Monday and is numbered 1.

+ return_type = 11 -> week starting on Monday and numbered 1.

+ return_type = 12 -> week starting on the 3rd and numbered 1.

+ return_type = 13 -> week starts on Wednesday and is numbered 1.

+ return_type = 14 -> week starts on the 5th and is numbered 1.

+ return_type = 15 -> week starts on Friday and is numbered 1.

+ return_type = 16 -> week starts on Saturday and is numbered 1.

+ return_type = 17 -> The week starting on Sunday is numbered 1.

+ return_type = 21 -> week starts on Monday and is numbered 2.

Attention:

- Excel stores dates as sequential serial numbers to facilitate the calculation process.

- If the Serial_number value is outside the basic range of the date value -> the function returns the #NUM! Error value

- If the return_type value is not in its values as above -> the function returns the #NUM! Error value

For example:

Calculate the ordinal number of the week in the year containing the following dates:

WEEKNUM function - The function returns the week number of the year in Excel Picture 2

- In the cell to calculate enter the formula: = WEEKNUM (E7, F7).

WEEKNUM function - The function returns the week number of the year in Excel Picture 3

- Press Enter -> 1/1/2016 at the 1st week of the year:

WEEKNUM function - The function returns the week number of the year in Excel Picture 4

- Similarly copying the formula for the remaining values results:

WEEKNUM function - The function returns the week number of the year in Excel Picture 5

- Case:

+ The serial_number value is an invalid date -> the function returns the error value #VALUE!

+ The return_type value is outside the range of values -> the function returns the #NUM! Error value

WEEKNUM function - The function returns the week number of the year in Excel Picture 6

Above are instructions and some specific examples when working with WEEKNUM function in Excel.

Good luck!

Lesley Montoya

Update 19 May 2020

You should read it

May be interested

ISODD function - The function returns True if the value is an odd number in Excel
isodd function: the function returns true if the value is odd. application of functions to check odd and even numbers. syntax: isodd (number)
PERMUTATIONA function - The function returns the number of permutations (can be repeated) of a given object in Excel
permutationa function: the function returns the number of permutations (can be repeated) of a given object. support functions from excel 2013 onwards. syntax: permutationa (number, number_chosen)
GAMMA function - The function returns the gamma function value in Excel
gamma: the function returns the gamma function. support functions from excel 2013 onwards. syntax: gamma (number)
POISSON.DIST function - The function returns the Poisson distribution in Excel
poisson.dist function: the function returns the poisson distribution, the application function to predict the number of events in a specific time. support functions from excel 2013 onwards. syntax: poisson.dist (x, mean, cumulative)
RANK.EQ function - Function returns the rank of a number in a list of numbers, returns the highest rank when multiple values with the same rank in Excel
rank.eq function: the function returns the rank of a number in a list of numbers whose size is in correlation with other values. if multiple values have the same rank -> the function returns the highest rank. support functions from execl 2010 version onwards.
SHEETS function - The function returns the number of pages in a reference in Excel
sheets function: the function returns the number of pages in a reference. support functions from excel 2013 onwards. syntax: sheets (reference)
BETA.DIST function - The function returns the Beta distribution in Excel
beta.dist function: the function returns the beta distribution to study the variability of a number of things through a sample. support functions from excel 2010 onwards. syntax: beta.dist (x, alpha, beta, cumulative, [a], [b])
The SQRT function returns the square root of a positive number in Excel
the sqrt () function in excel helps you quickly calculate the square root of any number you want. the syntax and usage of the function is very simple, but if you do not know, follow the article below.
How to use ADDRESS function in Excel
the address function in excel takes the number of rows and column numbers as arguments and returns the reference of the standard cell (cell address). for example, if you go to row 4 and column 3, the function returns c4.
POISSON function - The function returns the Poisson distribution in Excel
in predicting the number of events that occur within a specific time, one cannot help but use the poisson function. the following article details how to use the poisson function, the function returns the poisson distribution.

WEEKNUM function - The function returns the week number of the year in Excel

You should read it

May be interested

Office information