Hi Steve,
If the earliest date is in A1, the latest date in C1 and the test date is in
B1, and all dates are stored as values, you could use something like:
=IF(AND(B1>A1,B1<C1),"Yes","No")
This tests whether B1 is *between* A1 and C1.
If you want to include A1 and C1 as valid dates, use something like:
=IF(OR(B1<A1,B1>C1),"No","Yes")
Cheers
