This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We're excited to announce that we'll be partnering with Credly starting October 19th - see what this means and read the announcement blog here!
I used the following formula today to determine if a year was a leap year. Thought I would share in case others needed this as well.
IF IsInteger([YEAR]/400) THEN "YES" ELSEIF IsInteger([YEAR]/4) AND !IsInteger([YEAR]/100) THEN "YES" ELSE "NO" ENDIF
Thanks for sharing! Here is the formula I use for finding a Leap Year.
Since we know that every leap year will have 29 days in February, I use the datetime functions to find the last day Feb for each year.