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 foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Shortcuts Video Course
Excel Charts video training course
Video training for Excel Tables