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
- =ISLEAPYEAR(2000) = TRUE
- =ISLEAPYEAR(1998) = FALSE
- =ISLEAPYEAR(3004) = TRUE
- =ISLEAPYEAR() = FALSE
Related Videos
See Also
References