Joe,

I stand corrected. :-) The indenting got me.

Sorry.

Jeff

>IF the year is divisible by 4---->1) Yes
>...IF the year is divisible by 100---->2) No
>......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---->3) 1996 is a leap year.
>...ENDIF
>ELSE
>...It is not a leap year
>ENDIF
>
>
>It works. It is how it is done.
>
>Joe
>
>
>>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