Try something like the following:

=IF(AND(B2=DATE(2007,8,16),B2<=DATE(2007,11,16)), TRUE,FALSE)

The formula compares the value in cell B2 to see if it falls between the 2
dates specified. The syntax for DATE is DATE(year,month,day) and the AND
function lets you state the date range.

--
Kevin Backmann


"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