Michael,

If you need an exact match:

=IF(ISERROR(MATCH(A1,B1:B4,FALSE)),"a something","something else")

If you need it within the range defined by the dates in B1:B4

=IF(AND(A1=MIN(B1:B4),A1<=MAX(B1:B4)),"something else","a something")

HTH,
Bernie
MS Excel MVP


wrote in message
oups.com...
This should be easy, but for the life of me I can't figure it out. I
have one cell that has a date (a1) in it. I want to verify that date
against a range of dates (b1:b4) (it needs to be in that range) that I
have in a column, while using an if/and statement. The statement I
want to use is something to the effect of (in words): if a1 is a
thursday and is in the range b1:b4, give me a something, otherwise give
me something else. Am I making this harder than it should be?