The WEEKDAY Function in Excel returns an integer that represents a day of the week. This function will return a value between 0 and 7. By default, Excel will return a value between 1 and 7.
| Result | Day |
| 1 | Monday |
| 2 | Tuesday |
| 3 | Wednesday |
| 4 | Thursday |
| 5 | Friday |
| 6 | Saturday |
| 7 | Sunday |
Syntax:
=WEEKDAY(serial_number,[return_type])
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. See options below.
Please note, if we omit the return_type argument, it will take the default value of 1.
For a better understanding of dates in Excel, refer to the following tutorial. It provides an overview on how dates are stored and processed. How Excel stores dates
WEEKDAY Function Usage Example
Let’s look at the following example.
Here we show how this function in used with various Return Type arguments using the same date. You can see how the results vary.
