ISLEAPYEAR function

CALC FUNCTIONS

Date & Time Functions

< Previous Section

Next Section >

FUNCTIONS

• TODAY
• NOW
• YEAR
• MONTH
• DAY
• WEEKDAY
• HOUR
• MINUTE
• SECOND
• DATE
• DATEVALUE
• TIME
• TIMEVALUE
• EOMONTH
• EDATE
• WORKDAY
• NETWORKDAYS
• DAYS
• DAYS360
• DAYSINMONTH
• DAYSINYEAR
• WEEKS
• WEEKSINYEAR
• WEEKNUM
• WEEKNUM_ADD
• MONTHS
• YEARS
• ISLEAPYEAR
• EASTERSUNDAY
• YEARFRAC

< Previous Page

Next Page >

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

• DAYSINMONTH
• DAYSINYEAR

• Information functions

• Date & Time overview

• Date & Time functions

• Functions listed alphabetically
• Functions listed by category