Documentation/Calc Functions/DAYSINMONTH/en

Function name:
DAYSINMONTH

Category:
Date and Time

Summary:
Calculates the number of days in the month in which the specified date lies.

Syntax:
DAYSINMONTH(Date)

Returns:
Returns an integer value in the range 1 to 31, which is the number of days in the month in which the specified date lies.

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 DAYSINMONTH reports a #VALUE! error.
 * DAYSINMONTH ignores any time components of Date.

Details specific to DAYSINMONTH function
DAYSINMONTH is not part of the ODF 1.2 international standard and should not be regarded as portable. If portability is important for your spreadsheet, try the following formula as an alternative to DAYSINMONTH.

Related LibreOffice functions:
DAYSINYEAR

ODF standard:
None.

Equivalent Excel functions:
None.