Detect Leap Years


If A1 is a leap year, the above formula will return TRUE

Actually I was told that the above formula is incorrect by Rick Blaiklock. According to Wikipedia (

The Gregorian calendar adds an extra day to February, making it 29 days long, in years divisible by 4, excepting years divisible by 100, but including years divisible by 400. So 1996, 2000, and 2400 are leap years but 1800, 1900 and 2100 are not. (The Gregorian calendar seems to be the one in use in most countries but you might want to check just in case)

Wow, I never knew that. Anyway, here is my "improved" formula as a workaround.


Here's a shorter one suggested by Jason Morin. Very nice!


© Copyright All Rights Reserved.