Documentation/Calc Functions/ISLEAPYEAR/en

Function name:
ISLEAPYEAR

Category:
Date and Time

Summary:
Determines whether a given date lies in a leap year.

Syntax:
ISLEAPYEAR(Date)

Returns:
Returns 1 (TRUE) to indicate that the specified date lies within a leap year and 0 (FALSE) otherwise.

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, for which the calculation is to be carried out.


 * If Date does not contain a valid date expression, then ISLEAPYEAR reports a #VALUE! error.
 * ISLEAPYEAR ignores time, day, and month components of Date.

Details specific to ISLEAPYEAR function
ISLEAPYEAR is not part of the ODF 1.2 international standard and should not be regarded as portable.

Visit Wikipedia’s Leap year page for more information about leap years and how they are determined in the Gregorian calendar.

Related LibreOffice functions:
None.

ODF standard:
None.

Equivalent Excel functions:
None.