by Sometimes you need to know what day is the order of the week for your calculations, the WEEKDAY function in Excel is a calculation function that can help and help you do this. Let’s find out about the WEEKDAY function in Excel through the tips below.
Syntax: =WEEKDAY(serial_number,[return_type])
The WEEKDAY function syntax has the following arguments:
- Serial_number (required argument) – This is a sequential number representing the date of the day that we are trying to find.
- Return_type (optional argument) – This specifies which integers are to be assigned to each weekday. Possible values are:
WEEKDAY accepts a date and returns a number between 1-7 representing the day of week for that date. By default, WEEKDAY returns 1 for Sunday and 7 for Saturday, as shown in the table below:
| Result | Meaning |
|---|---|
| 1 | Sunday |
| 2 | Monday |
| 3 | Tuesday |
| 4 | Wednesday |
| 5 | Thursday |
| 6 | Friday |
| 7 | Saturday |
WEEKDAY supports several numbering schemes. The return type argument determines which scheme used to map each day of week to a number. The return type is optional and defaults to 1. The table below shows the result and mapping associated with each return type:
| Return type | Numeric result | Day mapping |
|---|---|---|
| none | 1-7 | Sunday-Saturday |
| 1 | 1-7 | Sunday-Saturday |
| 2 | 1-7 | Monday-Sunday |
| 3 | 0-6 | Monday-Sunday |
| 11 | 1-7 | Monday-Sunday |
| 12 | 1-7 | Tuesday-Monday |
| 13 | 1-7 | Wednesday-Tuesday |
| 14 | 1-7 | Thursday-Wednesday |
| 15 | 1-7 | Friday-Thursday |
| 16 | 1-7 | Saturday-Friday |
| 17 | 1-7 | Sunday-Saturday |
Note: the WEEKDAY function will return a value even when the date is empty. Take care to trap this result if blank dates are possible.
Example: Let’s look at some Excel WEEKDAY function examples and explore how to use the WEEKDAY function as a worksheet function in Microsoft Excel:
Syntax: =WEEKDAY(A2)
Result:
=WEEKDAY(A3)
Result: 6
=WEEKDAY(A4)
Result: 7
=WEEKDAY(A5)
Result: 1
=WEEKDAY(A6)
Result: 2
=WEEKDAY(A7)
Result: 3
=WEEKDAY(A8)
Result:4
=WEEKDAY(A9)
Result: 5
=WEEKDAY(A10)
Result: 2
=WEEKDAY(A11)
Result: 6
Wish you success and soon remember the formula of Weekday function to serve calculations when working on Excel.
