Manuals/calci/ISLEAPYEAR

ISLEAPYEAR(year)

• $year$ is the year to find whether it is leap year or not.

Description

• This function is one of the group in $ISFUNCTIONS$.
• The $ISFUNCTION$ is also known as data information functions, data inspection functions or data-testing functions.
• $ISLEAPYEAR$ function is used to find the year is leap year or not.
• The function is giving the result as TRUE when the given year is leap year otherwise this function will return as FALSE.
• When we omitting the year value then the function will return the result as FALSE.
• For the ISFUNCTION the argument can be blank, or it can contain data such as text, numbers, error values, or logical values.

ZOS Section

• The syntax is to find whether the given year is leap or not in ZOS is $ISLEAPYEAR(year)$.
  • $year$ is the year to find whether it is leap year or not.
• For e.g.,ISLEAPYEAR(2003..2008)

Examples

1. =ISLEAPYEAR(2000) = TRUE
2. =ISLEAPYEAR(1998) = FALSE
3. =ISLEAPYEAR(3004) = TRUE
4. =ISLEAPYEAR() = FALSE

See Also

• ISNUMBER
• ISODD
• ISEVEN

References

Is functions