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!

Lesley Montoya

Update 19 May 2020

You should read it

May be interested

WEEKNUM 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:
The WORKDAY function - The function returns a date before or after the start date of a number of working days in Excel
workday - the function returns a date before or after the start date of a specified number of working days. weekends and public holidays do not count toward business days. syntax: workday (start_date, days, [holidays])
The WORKDAY.INTL function - The function returns a date before or after the date starting with a custom weekend in Excel
workday.intl: the function returns a date before or after the start date of a specified number of working days with a custom weekend. the weekend parameter indicates which day and how many days. syntax: workday (start_date, days, [weekend], [holidays])
YEAR - The function returns the year corresponding to a date in Excel
year: the function returns the year value corresponding to a date in excel. the year value returns an integer with a value between 1900 and 9999. syntax: year (serial_number).
YEARFRAC function - The function returns the fifth calculated by the number of whole days between two specific dates in Excel
yearfrac function: the function returns the fifth calculated by the number of whole days between two specific dates in excel. syntax: yearfrac (start_date, end_date, [basis])
NETWORKDAYS.INTL function - The function returns the number of whole working days between 2 dates, specifying weekends in Excel
networkdays.intl: the function returns the number of whole working days between two dates by using a parameter that determines the number of weekends and which day of the week. syntax: networkdays.intl (start_date, end_date, [weekend], [holidays])

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

You should read it

May be interested

Office information