=IF(AND(A1=36526,A1<37257),TRUE,FALSE)

Vaya con Dios,
Chuck, CABGx3



"Jason" wrote in message
...
I am trying to write and if statment to include only 2001 dates. However,
I
have dates both in 2000 and 2002. I tried the writing the following
statment
and excel keeps giving me an error:

=IF(Date Field=1/1/2000 AND <1/1/2002, TRUE, FALSE)

Apparently excel doesn't like the and part. How can I go about getting
around this or writing the formula with a new word or character that excel
will accept?

Thanks,

jason