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.