One way: =IF(COUNTIF(Sheet2!A1:Sheet2!A5,A1)0,"yes", "no")

HTH

Penny

"jim314" wrote in message
...
I'm trying to determine if a date in Sheet1 is in a list of dates in
Sheet2
(returning a simple, "YES" or "NO").

Example:
Sheet1:

A1 contains the following date: 09/01/05
B1 should contain the "YES" or "NO"

Sheet2:
Column A contains a list of dates, such as the following:
01/01/05
02/14/05
09/01/05
12/25/05
12/31/05

What is the best way to return a "YES" or "NO"? I have tried
unsuccessfully
to do this with an if/then, but I'm thinking there must be a better way.

Thanks,

Jim