Weekday
Syntax
Weekday(date_value)
Description
Returns an integer value, ranging from 1 through 7, which represents the day of the week for the date value provided as a parameter, where Sunday equals 1 and Saturday equals 7.
Parameters
| Parameter | Description |
|---|---|
|
date_value |
A date value, such as the value returned by the Date() function, or “10/29/2104” |
Returns
Returns an integer value, ranging from 1 through 7, which represents the day of the week for the date value provided as a parameter, where Sunday equals 1 and Saturday equals 7.
Example
The following table presents examples of using the Weekday function; the second example assumes that Tuesday is the weekday of the current date:
| Expression | Result |
|---|---|
|
Weekday(October 18, 2014) |
6 |
|
Weekday(Date()) |
3 |
|
Weekday("07/29/2013") |
2 |