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