Joseph,

This will not work. 1996 was a leap year but does not match the structure below.
There have been multiple treads on the calculation of a leap year. Search for Leap Year and you should have some good examples.

HTH

Jeff Whitaker

>Yeah...
>
>IF the year is divisible by 4
>...IF the year is divisible by 100
>......IF the year is divisible by 400
>.........It is a leap year
>......ELSE
>.........It is not a leap year
>......ENDIF
>...ELSE
>......It is a leap year
>...ENDIF
>ELSE
>...It is not a leap year
>ENDIF
>
>
>
>>I need a function to calculate leap years. Any suggestions? Thanks,
>>
>>Raef