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")
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
