Get the day of the week corresponding to the date.
How it works
=WEEKDAY(Serial_number,Value1 to Value254)
| Argument | Omission | Specify |
|---|---|---|
| Serial_number | Required argument. | Specify the date to get the day of the week. |
| Return_type | 1 | Specify the criteria for the week. (Which day of the week is considered 1) |
| Return_type | Mo. | Tu. | We. | Th. | Fr. | Sa. | Su. |
|---|---|---|---|---|---|---|---|
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 1 |
| 2 | 1 | 2 | 3 | 4 | 5 | 6 | 7 |
| 3 | 0 | 1 | 2 | 3 | 4 | 5 | 6 |
| 11 | 1 | 2 | 3 | 4 | 5 | 6 | 7 |
| 12 | 7 | 1 | 2 | 3 | 4 | 5 | 6 |
| 13 | 6 | 7 | 1 | 2 | 3 | 4 | 5 |
| 14 | 5 | 6 | 7 | 1 | 2 | 3 | 4 |
| 15 | 4 | 5 | 6 | 7 | 1 | 2 | 3 |
| 16 | 3 | 4 | 5 | 6 | 7 | 1 | 2 |
| 17 | 2 | 3 | 4 | 5 | 6 | 7 | 1 |
Example Results
The following are examples of cases where "Return_type" is 1 and 2.
The difference is where the first day of the week begins, and whether it starts with 0 or 1.
Therefore, choose the one that is easiest to use depending on your application.
Spill
If you specify the argument the cell range, it will be Spill.
---