The issue is how you expressed your dates

Try =AND(A2=DATE(2009,10,1),A2<=DATE(2009,10,24))

As written Excel does not recognize 10/1/2009 as a date, it does the math 10
divided by 1 divided by 2009
--
If this helps, please remember to click yes.


"gamn" wrote:

I have a problem using AND function on date data.

In cell A2, I have date date "10/1/2009".

In cell A3, I have AND fuction as =AND(A2=10/1/2009, A2<=10/24/2009). This
should return a TRUE but instead returns FALSE. Why?


Thank you, BB