Prev: "AND FUNCTION" RETURNS FALSE WHEN CRITERIA IS TRUELY MET. HELP!!!
Next: Indirect and Sheet Name
From: gamn on 23 Mar 2010 17:35
I tried that but still a NO-GO. See link for a screen shot.


https://emerson.sendthisfile.com/GvndbnUZAtYGVN1QSDhpQeoc

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
From: Fred Smith on 23 Mar 2010 17:58
As explained by Paul, the order of parameters for the Date function is:
year, month, day.

Regards,
Fred

"gamn" <gamn(a)discussions.microsoft.com> wrote in message
news:F8195942-53E6-4714-910A-81621054C242(a)microsoft.com...
>I tried that but still a NO-GO. See link for a screen shot.
>
>
> https://emerson.sendthisfile.com/GvndbnUZAtYGVN1QSDhpQeoc
>
> 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

From: Bernard Liengme on 23 Mar 2010 18:22
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
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"gamn" <gamn(a)discussions.microsoft.com> wrote in message
news:F8195942-53E6-4714-910A-81621054C242(a)microsoft.com...
> I tried that but still a NO-GO. See link for a screen shot.
>
>
> https://emerson.sendthisfile.com/GvndbnUZAtYGVN1QSDhpQeoc
>
> 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

 | 
Pages: 1
Prev: "AND FUNCTION" RETURNS FALSE WHEN CRITERIA IS TRUELY MET. HELP!!!
Next: Indirect and Sheet Name