It returns the day of the week corresponding to a date. The day is given as an integer, ranging from 1 to 7.
The syntax of the function is the following:
WEEKDAY(serial_number, [return_type])
serial_number: It represents the date for which we want to return the day of the week.
[return_type]: Optional. Default is 1. It is a number that defines the type of the return value.
| return_type | Definition |
| 1 | Returns (1=Sunday to 7=Saturday) |
| 2 | Returns (1=Monday to 7=Sunday) |
| 3 | Returns (0=Monday to 6=Sunday) |
| 11 | Returns (1=Monday to 7=Sunday) |
| 12 | Returns (1=Tuesday to 7=Monday) |
| 13 | Returns (1=Wednesday to 7=Tuesday) |
| 14 | Returns (1=Thursday to 7=Wednesday) |
| 15 | Returns (1=Friday to 7=Thursday) |
| 16 | Returns (1=Saturday to 7=Friday) |
| 17 | Returns (1=Sunday to 7=Saturday) |
Click on the button to practice using this function, with the help of our Online Assessment Tool:
Here is an example of how to use the WEEKDAY function:
Use the proper formula in the cell I2 to display the number of the day of the week (Sunday=1,Monday=2,…), which appears in the cell A2.