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.





  • 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

Leave a Reply

INDEX Function

INDEX Function in Excel The Index Function in Excel returns the value of an array given a specific row and

Read More »

If Function

The IF Function in excel is a logical test that can be run using specific conditions. This logical test returns

Read More »
Scroll to Top