DAY function

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])
datetime	Any string commonly recognized as a date and time or a reference to a cell containing a date and time.
expression	Any expression that yields a date and time.
lcid	Optional argument. Specifies the locale identifier to be used in evaluating a nonlocal datetime. The locale identifier is a number described in the system header files.

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 3:45:24 PM")

Returns 30.

Example 2

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

Returns 6.

Example 3

DAY(35580.6337)

Returns 30.