Documentation/Calc Functions/MONTH/en

Function name:
MONTH

Category:
Date and Time

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

Syntax:
MONTH(Date)

Returns:
Returns an integer in the range 1 (January) to 12 (December), which is the month value of 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 MONTH reports a #VALUE! error.
 * MONTH ignores any time components of Date.

Related LibreOffice functions:
DAY

YEAR

ODF standard:
Section 6.10.13, part 2

Equivalent Excel functions:
MONTH