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

WEEKNUM Function

The WEEKNUM Function in Excel will return the week number for a specific date. This function will return an integer

Read More »

SUMIFS Function

The SUMIFS function in Excel sums up particular cells based upon multiple criteria. The Sumif Function is only able to

Read More »
Scroll to Top