- Applies to: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2019, Excel 2016, Excel 2019 for Mac, Excel 2013, Excel 2010, Excel 2007, Excel 2016 for Mac, Excel for Mac 2011, Excel Starter 2010.
This post outlines the formula syntax and usage of the WEEKDAY function in Microsoft Excel.
WEEKDAY function Description
Returns the day of the week relating to a date. The day is given as an integer, ranging from 1 (Sunday) to 7 (Saturday), automatically.
WEEKDAY function Syntax
The WEEKDAY function syntax has the following arguments:
- Serial_number – Required. A sequential number that symbolises the date of the day you are searching for. Dates must be typed by using the DATE function, or as outcomes of other formulas or functions. For instance, use DATE(2008,5,23) for the 23rd day of May, 2008. Problems can arise if dates are stated as text.
- Return_type – Optional. A number that dictates the type of return value.
|1 or omitted||Numbers 1 (Sunday) to 7 (Saturday). Acts like former versions of Microsoft Excel.|
|2||Numbers 1 (Monday) to 7 (Sunday).|
|3||Numbers 0 (Monday) to 6 (Sunday).|
|11||Numbers 1 (Monday) to 7 (Sunday).|
|12||Numbers 1 (Tuesday) to 7 (Monday).|
|13||Numbers 1 (Wednesday) to 7 (Tuesday).|
|14||Numbers 1 (Thursday) to 7 (Wednesday).|
|15||Numbers 1 (Friday) to 7 (Thursday).|
|16||Numbers 1 (Saturday) to 7 (Friday).|
|17||Numbers 1 (Sunday) to 7 (Saturday).|
- Microsoft Excel holds dates as sequential serial numbers, allowing their usage in calculations. Automatically, January 1, 1900 is serial number 1, and January 1, 2008 is serial number 39448 since it is 39,448 days after January 1, 1900.
- If serial_number is beyond the range for the current date base value, a #NUM! error is returned.
- If return_type exceeds the range elaborated in the table above, a #NUM! error is returned.
Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter. If you need to, you can adjust the column widths to see all the data.
|=WEEKDAY(A2)||Day of the week, with numbers 1 (Sunday) through 7 (Saturday) (5)||5|
|=WEEKDAY(A2, 2)||Day of the week, with numbers 1 (Monday) through 7 (Sunday) (4)||4|
|=WEEKDAY(A2, 3)||Day of the week, with numbers 0 (Monday) through 6 (Sunday) (3)||3|