Difference between revisions of "Documentation/How Tos/Calc: ISLEAPYEAR function"

From Apache OpenOffice Wiki
Jump to: navigation, search
(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:

DAYSINMONTH

Information functions

Date & Time functions

Date & Time overview

Issues:

  • This function is not available in Excel.
Personal tools