The DAY
function returns a day of the month
when given a date value.
- The syntax
for the function is DAY (date)
. The "date"
must be a date value or a recognizable
date format in Excel.
Excel recognizes
other date formats and automatically
converts them into date values then
the day of the month is extracted from
the date value and a number is given
between 0 and 31.
For example: DAY (14-May-2003) =
14 and DAY (12/31/2003) = 31.
In addition the
DAY function can extract the day of
the month directly from the date value
DAY(39099) =17.
|
