On Tue, 23 Mar 2010 13:47:01 -0700, gamn
wrote:

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?

because 10/1/2009 is not the same as "10/1/2009"

The latter, in A2, is interpreted as a date and stored as an integer probably
equal to 40087, depending on the date system you are using in Excel.

The former: 10/1/2009 is computed as 10÷1÷2009 or 0.004978.

To unambiguously enter a date into your formula, you should either use a cell
reference containing the date, or use the DATE function. eg:

=and(a2=date(2009,10,1),a2<=date(2009,10,24))

--ron