WEEKDAY function. Get the day of the week corresponding to the date.(Microsoft Excel)
Get the day of the week corresponding to the date.
Contents
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.

---
Discussion
New Comments
No comments yet. Be the first one!