Skip to main content

WEEKDAY

Definition of WEEKDAY

Returns a number representing the day of the week of the date provided.

Sample Usage

WEEKDAY(DATE(1969,7,20))

WEEKDAY(A2)

WEEKDAY(40909)

WEEKDAY(40909,3)

Syntax

WEEKDAY(date, [type])
  • date - The date for which to determine the day of the week. Must be a reference to a cell containing a date, a function returning a date type, or a number.
  • type - [ OPTIONAL - 1 by default ] - A number indicating which numbering system to use to represent weekdays. By default counts starting with Sunday = 1.
    • If type is 1, days are counted from Sunday and the value of Sunday is 1, therefore the value of Saturday is 7.
    • If type is 2, days are counted from Monday and the value of Monday is 1, therefore the value of Sunday is 7.
    • If type is 3, days are counted from Monday and the value of Monday is 0, therefore the value of Sunday is 6.

Notes

  • Ensure that the input to the function is either a reference to a cell containing a date, a function which returns a date object such as DATEDATEVALUE or TO_DATE, or a date serial number of the type returned by the N function.
  • WEEKDAY does not autoconvert number formats. Therefore, WEEKDAY(10/10/2000) is interpreted as WEEKDAY(0.0005), the quotient of 10 divided by 10 divided by 2000.
  • WEEKDAY returns the day of week in numeric form, not as a letter (e.g. 'M' or 'F') an abbreviation (e.g. 'Tue' or 'Thu') nor as a full day name (e.g. 'Wednesday'). To get the name of the weekday, use the TEXT function or change the number formatting on the cell.

See Also

YEAR: Returns the year specified by a given date.

TO_DATE: Converts a provided number to a date.

N: Returns the argument provided as a number.

MONTH: Returns the month of the year a specific date falls in, in numeric format.

DAY: Returns the day of the month that a specific date falls on, in numeric format.

DATEVALUE: Converts a provided date string in a known format to a date value.

DATE: Converts a provided year, month, and day into a date.

TEXT: Converts a number into text according to a specified format.

In order to use the WEEKDAY formula, start with your edited Excellentable

Then type in the WEEKDAY Formula in the area you would like to display the outcome:

By adding the values you would like to calculate, Excellentable generates the outcome:

Error.

User does not have sufficient privileges to access this Content
Learn More

 

 

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.