View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
GAMN GAMN is offline
external usenet poster
 
Posts: 3
Default "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