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])
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)
Returns 30.