Assuming your date is in cell A1 this formula will return true or false...

=AND(A1=DATE(2007,8,16),A1<=DATE(2007,11,15))
--
HTH...

Jim Thomlinson


"Jimmy" wrote:

I have date ranges that certain things happen on. I need a formula that can
read a cell and determine if it's in betweeen August 16 and November 15, for
example, and return a value if it's true. I'm not sure how to get it to
work.

Thanks