Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
WEEKDAY Function
Collapse the table of content
Expand the table of content

WEEKDAY Function (VisioShapeSheet)

Last modified: June 17, 2011

Applies to: Office 2013 | Visio 2013

In this article
Syntax
Remarks
Example 1
Example 2
Example 3

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

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

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.

WEEKDAY("May 30, 1999")

Returns 7.

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

Returns 2.

WEEKDAY(35880.6337)

Returns 4.

Show:
© 2015 Microsoft