How to use the WEEKDAY function
Converts a date to a weekday number from 1 to 7.
Formula in cell D3:
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. |
This extensive function reference list provides detailed information including syntax, arguments, return values, and examples for many of the functions used in Excel formulas. Click on headers to sort table.
Articles with the 'WEEKDAY' Function
The following 5 articles have formulas that contain the WEEKDAY function.
Populate cells dynamically in a weekly schedule
In this post I am going to add one more function to the weekly schedule I built in a previous [โฆ]
The image above shows a calendar that is dynamic meaning you choose year and month and the calendar instantly updates [โฆ]
I have built a sheet to track time at work. It is very simple, there are 13 sheets, one for each [โฆ]
Count a specific weekday in a date range
NETWORKDAYS function returns the number of whole workdays between two dates, however the array formula I am going to demonstrate [โฆ]
La Thăng asks: I want to find day if given date and week, for example : if given Tuesday, 32th [โฆ]
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 [โฆ]
How to use the DATEDIF function
The DATEDIF function returns the number of days, months, or years between two dates. The DATEDIF function exists in order to [โฆ]
How to use the DATEVALUE function
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 [โฆ]
How to use the EOMONTH function
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.) [โฆ]
How to use the MINUTE function
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 [โฆ]
How to use the NETWORKDAYS function
The NETWORKDAYS function returns the number of working days between two dates, excluding weekends. It also allows you to ignore [โฆ]
How to use the NETWORKDAYS.INTL function
The NETWORKDAYS.INTL function calculate 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 [โฆ]
How to use the SECOND function
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 [โฆ]
How to use the TIMEVALUE function
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 [โฆ]
How to use the WEEKDAY function
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]) [โฆ]
How to use the WEEKNUM function
The WEEKNUM function calculates a given date's week number based on a return_type parameter that determines which day the week [โฆ]
How to use the WORKDAY function
The WORKDAY function returns a date based on a start date and a given number of working days (nonweekend and [โฆ]
The YEAR function converts a date to a number representing the year in the date. The number is between 1900 [โฆ]
How to use the YEARFRAC function
The YEARFRAC function returns the fraction of the year based on the number of whole days between a start date [โฆ]
English
Spanish
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.
Contact Oscar
You can contact me through this contact form