DAY
Syntax:
DAY ( date-value )
Description: Computes the numeric Gregorian day for the date and/or time having the given date-value, taking into account the current date base value.
Arguments:
Name |
Type |
Description |
---|---|---|
date-value |
number, text |
The date and/or time whose day is to be computed. That date and/or time shall be expressed either as a serial value, in which case, its fractional part is ignored, or as a string-constant having any valid date and/or time format, in which case, any time information shall be ignored. |
Return Type and Value: number – The Gregorian day for the date and/or time having the given date-value. The returned value shall be in the range 1–31.
However, if date-value is out of range for the current date base value, #NUM!
is returned.