Embedded Files
Description
Description
IsLeapYearλ() determines if a date is in a leap year. This is important for certain calculations like determining interest rates using the Actual/Actual interest method which differs slightly from the Exact Days method (days/365) in that Exact Days always uses 365 in the denominator and Actual/Actual uses 366 when in a leap year.
Syntax
Syntax
IsLeapYearλ( Date)
Arguments:
Arguments:
Date
(Required) Date to determine if it is in a leap year.
Example
Example
Formula =IsLeapYearλ( "2024-01-01")
Result TRUE
NOTE! To convert output from TRUE/FALSE to 1/0 use function N() like so:
Formula =N( IsLeapYearλ( "2024-01-01"))
Result 1
Page updated
Google Sites
Report abuse