Change your if statement as illustrated below so that the date values are
treated as dates:

=IF(AND(A1DATE(2007,10,1),A1<DATE(2008,10,1)),"Ye s","No")

The syntax of the DATE Function is DATE(Year,Month,Day)

All the arguments require an integer entry.
--
Kevin Backmann


"JH" wrote:

I have a column of dates. I wish to create another column that tells me if
the date in the column falls within a range and if so to make a change or
not. For example
a b
10/3/2007 change
10/1/2005 no change
My formula =if(and(a110/1/2007,a1<10/1/2008),"Change","No Change") tells me
everything is "no change"
Could someone please tell me what I am doing wrong?
Thanks for your help.