The WEEKDAY() function returns a number for the day of the week corresponding to the date provided. The day is given as an integer, ranging from (Sunday) to (Saturday), by default. This function does NOT return the name of the day of the week directly.
In this post:
Required knowledge:
See full list of functions for:
1. Syntax
=WEEKDAY(serial_number, [return_type])
serial_number representing a date (in other words, a valid date)
return_type determines the type of the number returned
| Return_type | Number returned |
| 1 or omitted | Numbers 1 (Sunday) through 7 (Saturday). Behaves like previous versions of Microsoft Excel. |
| 2 | Numbers 1 (Monday) through 7 (Sunday). |
| 3 | Numbers 0 (Monday) through 6 (Sunday). |
| 11 | Numbers 1 (Monday) through 7 (Sunday). |
| 12 | Numbers 1 (Tuesday) through 7 (Monday). |
| 13 | Numbers 1 (Wednesday) through 7 (Tuesday). |
| 14 | Numbers 1 (Thursday) through 7 (Wednesday). |
| 15 | Numbers 1 (Friday) through 7 (Thursday). |
| 16 | Numbers 1 (Saturday) through 7 (Friday). |
| 17 | Numbers 1 (Sunday) through 7 (Saturday). |
References:
- Microsoft (no date) Microsoft Support. Available at: https://support.microsoft.com/en-us/office/weekday-function-60e44483-2ed1-439f-8bd0-e404c190949a (Accessed: 15 July 2023).