Exceljet

Quick, clean, and to the point

Excel WEEKDAY Function

Excel WEEKDAY function
Summary 

The Excel WEEKDAY function takes a date and returns a number between 1-7 representing the day of week. By default, WEEKDAY returns 1 for Sunday and 7 for Saturday. You can use the WEEKDAY function inside other formulas to check the day of week and react as needed. 

Purpose 
Get the day of the week as a number
Return value 
A number between 0 and 7.
Syntax 
=WEEKDAY (serial_number, [return_type])
Arguments 
  • serial_number - The date for which you want to get the day of week.
  • return_type - [optional] A number representing day of week mapping scheme. Default is 1.
Usage notes 

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.

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.