WEEKDAY function - The function returns the weekday of a corresponding date in Excel

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

WEEKDAY function - The function returns the weekday of a corresponding date in Excel Picture 1

Description: The function returns the day of the week for the corresponding day. The return value is an integer between 1 (Sunday) and 7 (Saturday).

Syntax: WEEKDAY (serial_number, [return_type])

Inside:

- serial_number: Date value to determine the day, is a required parameter.

- return_type: The value that determines the return type, is an optional parameter with the following values:

+ return_type = 1 or skip -> Specify value = 1 (Sunday respectively) until 7 (Saturday).

+ return_type = 2 -> Specify value = 1 (2nd correspondence) until 7 (Sunday).

+ return_type = 3 -> Specify value = 0 (2nd correspondence) until 6 (Sunday).

+ return_type = 11 -> Specify value = 1 (2nd correspondence) until 7 (Sunday).

+ return_type = 12 -> Specify the value = 1 (3rd correspondence) until 7 (2nd).

+ return_type = 13 -> Specify the value = 1 (corresponding to the 4th) until 7 (the 3rd).

+ return_type = 14 -> Determine the value = 1 (corresponding to the 5th) to 7 (the 4th).

+ return_type = 15 -> Specify the value = 1 (6th order) until 7 (5th).

+ return_type = 16 -> Specify value = 1 (corresponding to the 7th) to 7 (the sixth)

+ return_type = 17 -> Specify value = 1 (Sunday) until 7 (Saturday).

Attention:

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

- If serial_number is outside the base range price -> the function returns the #NUM! Error value

- If return_type is outside the range of values ​​specified above -> the function returns the #NUM! Error value

For example:

Find the dates of the following dates in different return_type values:

WEEKDAY function - The function returns the weekday of a corresponding date in Excel Picture 2

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

WEEKDAY function - The function returns the weekday of a corresponding date in Excel Picture 3

- Press Enter -> return value is:

WEEKDAY function - The function returns the weekday of a corresponding date in Excel Picture 4

- With the same date value but different return_type return type -> for different results:

WEEKDAY function - The function returns the weekday of a corresponding date in Excel Picture 5

- In case of entering the wrong date data, here enter the month value = 15 -> function returns the error value #VALUE!

WEEKDAY function - The function returns the weekday of a corresponding date in Excel Picture 6

- If the return_type value is outside its range -> the function returns the #NUM! Error value

WEEKDAY function - The function returns the weekday of a corresponding date in Excel Picture 7

Above are instructions and some specific examples when using WEEKDAY () function in Excel.

Good luck!