Manuals/calci/ISLEAPYEAR

ISLEAPYEAR(Year)


  • is the year to find whether it is leap year or not.
    • ISLEAPYEAR(),returns TRUE if the value is leap year.

Description

  • This function is one of the group in  .
  • The   is also known as data information functions, data inspection functions or data-testing functions.
  •   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

  • The syntax is to find whether the given year is leap or not in ZOS is  .
    •   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

Related Videos

LEAP YEAR

See Also

References

Is functions