DAY

Description

Returns the day of the month (1 to 31) that corresponds to the date represented by the supplied number.

Syntax

DAY ( number )

Parameter	Description
number	A date represented as: A serial number (for example 40339, which represents the DATEVALUE) Text (for example, "06-21-11" or "5-Jun-13")

Remarks

The date "1/1/1900" incorrectly returns 2 (rather than 1).

Examples

The following function (where the serial date 41430 represents June 5, 2013) returns 5:

DAY(41430)

The following function returns 21:

DAY("06-21-11")