Advanced Search
Formulas and Functions with Microsoft® Excel 2003
If you need to determine whether a given year is a leap year, the MOD() function can help. Leap years (with some exceptions) are years divisible by 4. So, a year is (usually) a leap year if the following formula returns 0:
=MOD(year, 4)
PREVIEW
Not a subscriber?
Start A Free Trial