WEEKDAY Function

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.

ResultDay
1Monday
2Tuesday
3Wednesday
4Thursday
5Friday
6Saturday
7Sunday

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.
weekday function chart

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.

Weekday Function same date