A leap year is defined as a year that is evenly divisible by 4, but not evenly divisible by 100 unless that year is also evenly divisible by 400. Confused? This is why this recipe exists! This recipe calculates whether or not a year is a leap year and the number of days in a year.
Calculating leap years
Getting ready
To prepare for this recipe, perform the following steps:
- Create a table using the following formula:
R03_Years = GENERATESERIES(1899,3000,1)
How to do it...
To implement this recipe, perform the following steps:
- Create the following columns in the R03_Years...