Documentation/Calc Functions/DAYSINMONTH

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

Under construction.
For now, see the system Help files.


Function name:

DAYSINMONTH

Category:

Date and Time

Summary:

Calculates the number of days of the month in which the date entered occurs.

Syntax:

DAYSINMONTH(Date)

Returns:

Arguments:

Date is any date in the respective month of the desired year. The Date parameter must be a valid date according to the locale settings of LibreOffice.

Additional details:

Examples:

=DAYSINMONTH(A1) returns 29 days if A1 contains 1968-02-17, a valid date for February 1968.

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: