Documentation/Calc Functions/DAY/en

Function name:
DAY

Category:
Date and Time

Summary:
Calculates the day of the month for a date specified either by a date-time serial number or in a text string.

Syntax:
DAY(Date)

Returns:
Returns an integer value in the range 1 to 31 which is the day of the month for the supplied date.

Arguments:
Date is the date (in quotation marks) or a date-time serial number, or a reference to the cell containing one of those types, which is the date for which the calculation is to be carried out.


 * If Date is not a valid date expression, then DAY reports a #VALUE! error.
 * DAY ignores any time components of Date.

Related LibreOffice functions:
MONTH

YEAR

ODF standard:
Section 6.10.5, part 2

Equivalent Excel functions:
DAY