Posted to microsoft.public.excel.worksheet.functions
|
|
"AND FUNCTION" RETURNS FALSE WHEN CRITERIA IS TRUELY MET. HEL
I tried that but still a NO-GO. See link for a screen shot.
https://emerson.sendthisfile.com/Gvn...YGVN1QSDhpQeoc
Thank you, BB
"Paul C" wrote:
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
|