ISLEAPYEAR function
From Apache OpenOffice Wiki
< Documentation | How Tos
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
ISLEAPYEAR
Tests if a date is in a leap year.
This function is only available if the Analysis AddIn is installed.
Syntax:
ISLEAPYEAR(date)
- Returns 1 if date lies in a leap year, and 0 otherwise.
Example:
ISLEAPYEAR("2012-05-24")
- returns 1; 2012 is a leap year.
Issues:
- This function is not available in Excel. Try =MONTH(DATE(YEAR(date);2;29))=2 if you need compatibility with Excel.
See Also
