Difference between revisions of "Documentation/How Tos/Calc: ISLEAPYEAR function"
From Apache OpenOffice Wiki
< Documentation | How Tos
(Initial content) |
|||
Line 23: | Line 23: | ||
'''[[Documentation/How_Tos/Calc: Date & Time functions#Date and Time overview|Date & Time overview]]''' | '''[[Documentation/How_Tos/Calc: Date & Time functions#Date and Time overview|Date & Time overview]]''' | ||
+ | |||
+ | === Issues: === | ||
+ | * This function is not available in Excel. |
Revision as of 05:32, 22 July 2008
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.
See also:
Issues:
- This function is not available in Excel.