Walter Meester
HoogkarspelNetherlands
Fred,
>>The year is divisable by 4 except for the century years which are not divisable by 4.
>>
>>(20 mod 4 = 0) --> leap year
>>(19 mod 4 = 3) --> not a leap year
>>
>>Walter,
>
>You must include the 100 & 400 checks. 2100, 2200, 2300 will NOT be leap years, but 2400 will be.
I did: the exception was for century years the century was not divisable by 4 (thus years not divisable by 400), though I must say I could have been more clear.
So:
Leapyear = MOD(nYear,4)=0 AND (MOD(nYear,100) # 0 OR MOD(nYear,400)=0)
Walter,
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only