How to use the WEEKDAY function
Article updated on January 16, 2018
Converts a date to a weekday number from 1 to 7.
Formula in cell D3:
=WEEKDAY(B3)
Excel Function Syntax
WEEKDAY(serial_number,[return_type])
Arguments
serial_number | Required. The Excel date value you want to extract the WEEKDAY number from. |
return_type | Optional. Determines the type of return value, see table below. |
Return_type | Number returned |
---|---|
1 or omitted | Numbers 1 to 7 for Sunday to Saturday. |
2 | Numbers 1 to 7 for Monday to Sunday. |
3 | Numbers 0 to 6 for Monday to Sunday. |
11 | Numbers 1 to 7 for Monday to Sunday. |
12 | Numbers 1 to 7 for Tuesday to Monday. |
13 | Numbers 1 to 7 for Wednesday to Tuesday. |
14 | Numbers 1 to 7 for Thursday to Wednesday. |
15 | Numbers 1 to 7 for Friday to Thursday . |
16 | Numbers 1 to 7 for Saturday to Friday . |
17 | Numbers 1 to 7 for Sunday to Saturday. |
Articles with the 'WEEKDAY' Function
The following 7 articles have formulas that contain the WEEKDAY function.
In this post I am going to add one more function to a weekly schedule, an array formula allows you […]
I have created a monthly calendar template for you to download. Download excel calendar template Week starts with sunday Monthly […]
I have built a sheet to track time at work. It is very simple, there are 13 sheets, one for each […]
Question: How to count, for example, mondays in a range? Answer: If your range looks like this (see picture below), […]
NETWORKDAYS function returns the number of whole workdays between two dates. The array formula in this blog post counts for […]
La Thăng asks: I want to find day if given date and week, for example : if given Tuesday, 32th […]
The NETWORKDAYS function allows you to count weekdays or workdays between two dates. It ignores weekends and a custom date list […]
Functions in 'Date and Time'
The WEEKDAY function function is one of many functions in the 'Date and Time' category.
The DATE function returns a number that acts as a date in the Excel environment. The image above shows you […]
The DATEDIF function returns the number of days, months, or years between two dates. The DATEDIF function exists in order to […]
The DATEVALUE function returns an Excel date value (serial number) based on a date stored as text. Excel Function Syntax […]
The DAY function extracts the day as a number from an Excel date. Formula in cell C3: =DAY(B3) Excel Function […]
The DATE function calculates the number of days between two dates. Formula in cell D3: =DAYS(B3,C3) Excel Function Syntax DAYS(end_date, […]
The EDATE function returns a date determined by a start date and a number representing how many months. Use EDATE […]
The EOMONTH function returns an Excel date for the last day of a given month using a number and a start […]
Returns an integer representing the hour of an Excel time value. The returning number is ranging from 0 (12:00 A.M.) […]
Returns a whole number representing the minute based on an Excel time value. The returned number is ranging from 0 […]
Extracts the month as a number from an Excel date. Formula in cell C3: =MONTH(B3) Excel Function Syntax MONTH(serial_number) Arguments […]
The NETWORKDAYS function returns the number of working days between two dates, excluding weekends. It also allows you to ignore […]
The NOW function returns the current date and time. Formula in cell B3: =NOW() Excel Function Syntax NOW() Arguments The […]
Returns an integer representing the second based on an Excel time value. The returning number is ranging from 0 to […]
The TIME function returns a decimal value between 0 (zero) representing 12:00:00 AM and 0.99988426 representing 11:59:59 P.M. Formula in cell […]
The TIMEVALUE function returns a decimal number based on a text string. Excel uses decimal numbers between 0 and 0.99988426 […]
The TODAY function returns the Excel date (serial number) of the current date. Warning! This function is volatile meaning it […]
Converts a date to a weekday number from 1 to 7. Formula in cell D3: =WEEKDAY(B3) Excel Function Syntax WEEKDAY(serial_number,[return_type]) […]
The YEAR function converts a date to a number representing the year in the date. The number is between 1900 […]