"AND FUNCTION" RETURNS FALSE WHEN CRITERIA IS TRUELY MET. HELP!!!

  • Thread starter Thread starter gamn
  • Start date Start date
G

gamn

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
 
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
 
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?
Click to expand...

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
 
As explained by Paul, the order of parameters for the Date function is:
year, month, day.

Regards,
Fred
 
But you did not follow Paul's advice! The syntax of the DATE function is
DATE(year, month, day). This is totally independent of you preferred data
format. In the screen capture you linked us to you have DATE(10,1,2009)
when you need DATE(2009,10,1)
best wishes
 
Back
Top