DAY Function (VisioShapeSheet)

Returns an integer, 1 to 31, representing the day in datetime or expression. The DAY function uses the Gregorian calendar.

Syntax

DAY(" 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	String	Any expression that yields a date and time.
lcid	Optional	Number	Specifies the locale identifier to be used in evaluating a non-local datetime. The locale identifier is a number described in the system header files.

Return value

Integer

Remarks

Any time component in datetime or expression is discarded.

No rounding is done. If datetime is missing or cannot be converted to a valid result, the function returns an error.

The DAY 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

DAY("May 30, 1997 15:45:24")

Returns 30.

Example 2

DAY(DATEVALUE("May 30, 1997")+7 ed.)

Returns 6.

Example 3

DAY(35580.6337)