"AND FUNCTION" RETURNS FALSE WHEN CRITERIA IS TRUELY MET. HELP!!!
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
|