WEEKDAY Function (VisioShapeSheet)

Returns an integer, 1 to 7, representing the weekday in datetime or expression.

Syntax

WEEKDAY(" ** datetime ** "| ** expression ** [, ** lcid ** ])

Parameters

Name Required/Optional Data Type Description
datetime
Required
String
Any string commonly recognized as a date and time or a reference to a cell containing a date and time.
expression
Required
Varies
Any expression that yields a date and time.
lcid
Optional
Numeric
The locale identifier to be used in evaluating a nonlocal datetime. The locale identifier is a number described in the system header files.

Return value

Integer

Remarks

The time component in datetime or expression is discarded.

The result corresponds to Monday (1) through Sunday (7). No rounding is done. If datetime is missing or cannot be interpreted as a valid date or time, the function returns a #VALUE! error.

The WEEKDAY function also accepts a single number value for expression where the integer portion of the result represents the number of days since December 30, 1899.

Example 1

WEEKDAY("May 30, 1999")

Returns 7.

Example 2

WEEKDAY(DATEVALUE("May 30, 1999")+2 ed.)

Returns 2.

Example 3

WEEKDAY(35880.6337)

Returns 4.