Menu
EXCEL WEEKDAY FUNCTION
Excel WEEKDAY Function Introduction
The Function returns the day of the week as a number between 1 and 7 (Sunday to Saturday). You can also use the return type option to alter the starting day from Sunday to Monday or any other day.
Description of Excel WEEKDAY Function
Syntax:
=WEEKDAY (date, [return_type])
Example :
WEEKDAY(DATE(1969,7,20))
WEEKDAY(A2)
WEEKDAY(40990)
Parameter list:
date – The date for which the day of the week is to be determined. A cell containing a date, a function yielding a date type, or a number must be referenced.
[ OPTIONAL – 1 by default ] type – A number specifying which weekday numbering scheme should be used. Counts beginning on Sunday are set to 1 by default.
Days are calculated from Sunday if type is 1, and the value of Sunday is 1, so the value of Saturday is 7.
If type is 2, days are counted from Monday, and Monday’s value is 1, so Sunday’s value is 7.
- If type is 3, days are counted from Monday, with Monday’s value of 0; hence, Sunday’s value is 6.
Step By Step Guide of WEEKDAY Function
Example:
All of the alternatives in this example use System 1, except for the last one, which uses System 2, in which the week containing the first Thursday of the year is the first week of the year. Because the 1st of January 2016 falls on a Friday, it will not be counted as a holiday.
the first week of the year, the fourth Because January 2016 falls on the first Thursday of the year, it will be the first week of the year.
Key Points
Make that the function’s input is either a reference to a cell with a date, a function that returns a date object like DATE, DATEVALUE, or TO DATE, or a date serial number of the kind produced by the N function.
WEEKDAY(10/10/2000) therefore becomes WEEKDAY(0.0005), the quotient of 10 divided by 10 divided by 2000.
WEEKDAY returns the weekday as a numeric value, not as a letter (e.g., ‘M’ or ‘F’), an acronym (e.g., ‘Tue’ or ‘Thu’), or a complete day name (e.g., ‘Wednesday’). Use the TEXT function or modify the number formatting on the cell to retrieve the name of the weekday.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
