Search Date within a range?

[doctortt]

Let say I have these two dates in two cells:

May 31st, 2014
August 31st, 2014

How do you write the formula to check whether June 30th, 2014 is within this date range? If yes, give me a TRUE;otherwise, FALSE

I can't figure this out....

[Simon Lloyd]

Assumin your date to look for is in B1 and the dates to look between are in C1 and D1 then this will work:
=IF(AND(B1>C1,B1<D1),"True","False")

[doctortt]

Assumin your date to look for is in B1 and the dates to look between are in C1 and D1 then this will work:
=IF(AND(B1>C1,B1<D1),"True","False")


It works great! Thanks