HomeApplicationOffice information

Compare WEEKDAY and WEEKNUM functions in Excel

The following article helps you clearly distinguish the meaning and usage between 2 functions WEEKDAY and WEEKNUM in Excel.

1. About meaning:

- Same: Both functions return sequence numbers.

- Different:

+ WEEKDAY function shows the number of the day of the week.

+ WEEKNUM function shows the ordinal number of the week of the year.

+ Return value:

* The WEEKDAY function is in the file {1, 2, 3, 4, 5, 6, 7}.

* The WEEKNUM function is greater than the value of the WEEKDAY function corresponding to the total number of weeks in the year.

2. Regarding the syntax:

2.1. WEEKDAY function

Syntax : WEEKDAY (serial_number, [return_type]) .

Inside:

- serial_number : is a sequence number representing the date to determine the day of the week, is a required parameter.

- return_type : is a number used to determine the type of return value, is an optional parameter, the default is 1, with the following values:

+ return_type = 1 or skip : Value from 1 (Sunday) to 7 (Saturday).

+ return_type = 2 : The number from 1 (Monday) to 7 (Sunday).

+ return_type = 3 : A number from 1 (Monday) to 7 (Sunday).

+ return_type = 11 : Number from 1 (Monday) to 7 (Sunday).

+ return_type = 12 : The number from 1 (Tuesday) to 7 (Monday).

+ return_type = 13 : The number from 1 (Wednesday) to 7 (Tuesday).

+ return_type = 14 : A number from 1 (Thursday) to 7 (Wednesday).

+ return_type = 15 : The number from 1 (Friday) to 7 (Thursday).

+ return_type = 16 : A number from 1 (Saturday) to 7 (Friday).

+ return_type = 17 : A number from 1 (Sunday) to 7 (Saturday).

2.2. WEEKNUM function

Syntax : WEEKNUM (serial_number, [return_type]) .

Inside:

- serial_number : A day of the week, is a required parameter.

- return_type : A number to determine the week starting from, the default value is 1 with the following values:

+ return_type = 1 or skip -> the week starts on Sunday and the value = 1.

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

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

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

+ return_type = 13 -> week starts on the 4th and value = 1.

+ return_type = 14 -> week starts on Thursday and value = 1.

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

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

+ return_type = 17 -> week starting on Sunday and value = 1.

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

Thus, the number of parameters of the two functions are the same but different in the parameters and return values.

3. For example:

Calculates the date 6/15/2016 and what day is in the week of the year.

Compare WEEKDAY and WEEKNUM functions in Excel Picture 1

- Calculate what day 6/15/2016 is the weekday.

In the cell to calculate enter the formula: = WEEKDAY (D6, D7) .

Compare WEEKDAY and WEEKNUM functions in Excel Picture 2

Press Enter -> result on 6/15/2016 is the 4th day of the week.

Compare WEEKDAY and WEEKNUM functions in Excel Picture 3

- Calculated on how many days of the year 6/15/2016 is in the year.

In the cell to calculate enter the formula: = WEEKNUM (D6, D7) .

Compare WEEKDAY and WEEKNUM functions in Excel Picture 4

Press Enter -> 6/15/2016 at the 25th week of 2016.

Compare WEEKDAY and WEEKNUM functions in Excel Picture 5

So with the same day using the 2 functions WEEKNUM and WEEKDAY will determine what day that day is in the week and how many days it is in the year.

Above is a comparison between the similarities and differences between 2 functions WEEKNUM and WEEKDAY hope to help you.

Good luck!

3.9 ★ | 18 Vote

You should read it

May be interested

  • Summary of information functions in ExcelSummary of information functions in Excel
    to facilitate the selection of functions to suit the requirements when you need to process information in excel spreadsheets. the following article summarizes the functions along with the functions of each function group in the excel spreadsheet.
  • WEEKNUM function - The function returns the week number of the year in ExcelWEEKNUM function - The function returns the week number of the year in Excel
    weeknum function - the function returns the ordinal number of the week of the year of the specified day in that week. there are 2 systems used in the function to determine the ordinal number of the week: - system 1: week with january 1 is the first week of the year and numbered as 1. - system 2:
  • Comparison functions in Excel - How to use comparison functions and examples using comparison functionsComparison functions in Excel - How to use comparison functions and examples using comparison functions
    comparison functions in excel - how to use comparison functions and examples using comparison functions with a large amount of data, you want to check for duplicates by checking normally, it is really hard. in this article, introduce to you the functions
  • How to compare 2 Excel files to see if there is any differenceHow to compare 2 Excel files to see if there is any difference
    if you work with excel spreadsheets regularly, we can easily find out the differences on excel files. but if you are new to excel and you have to compare 2 excel files to see what is different but do not know how? please follow the article below to answer that question!
  • Date time functions in ExcelDate time functions in Excel
    excel supports you to process and calculate quickly with the functions that excel provides such as calculation functions, date functions ... one of them is the function of time to help you handle the prices. time value: hour, minute, second conveniently
  • 10 EXCEL functions that ACCOUNTERS often use10 EXCEL functions that ACCOUNTERS often use
    in excel, there are many functions that can help accounting in daily data entry, but here are some common functions used by accounting.
  • How to Compare Data in ExcelHow to Compare Data in Excel
    this tipsmake article will show you how to compare two different data sets in excel, from two columns in the same spreadsheet to two independent excel files.
  • The 10 most useful but often forgotten functions in excelThe 10 most useful but often forgotten functions in excel
    microsoft excel is an extremely effective and effective calculation tool not only for accounting and office but also for many other industries.
  • Logical functions (logical) in ExcelLogical functions (logical) in Excel
    logical functions are used a lot during data processing in excel. the article summarizes the syntax and functions of functions in logical function groups in excel.
  • How to Compare Two Excel FilesHow to Compare Two Excel Files
    this article will show you how to directly compare data between two excel files. after manipulating and comparing information, you might consider using look up, index, and match to aid in analysis.

Office information