With your year in A1, the following will be True if it is a leap year, and
False if it's not:
=OR(MOD(A1,400)=0,AND(MOD(A1,4)=0,MOD(A1,100)<0))

It works for years 1900 and prior whereas Excel's date function will not.

Regards,
Fred.

"Mike M." wrote in message
...
I know the rule that a leap year has to be divisable by 400 or divisable by
4
& 100 but I can't figure out how to put it in a IF formaula. Can anyone
help?