AND array

[Dan]

Trying to use the AND function in an array but the response is always FALSE.

Looking for responses between yesterday and 21 days ago.
Equation: AND($E40:$E50<TODAY(),$E40:$E50>TODAY()-21)

I am selecting a range of cells F40:F50 before entering in the above
equation but each value is "FALSE"

Data in E
09/11/2005
19/12/2005
11/01/2006
08/03/2006 - should be TRUE
12/03/2006 - should be TRUE
22/03/2006 - should be TRUE
22/03/2006 - should be TRUE
16/06/2006
22/11/2004
23/12/2004
23/12/2004

Thanks

[JMB]

AND/OR do not work with arrays.

=(E4:E50<TODAY())+(E4:E50>TODAY()-21)=2


"Dan" wrote:

> Trying to use the AND function in an array but the response is always FALSE.
>
> Looking for responses between yesterday and 21 days ago.
> Equation: AND($E40:$E50<TODAY(),$E40:$E50>TODAY()-21)
>
> I am selecting a range of cells F40:F50 before entering in the above
> equation but each value is "FALSE"
>
> Data in E
> 09/11/2005
> 19/12/2005
> 11/01/2006
> 08/03/2006 - should be TRUE
> 12/03/2006 - should be TRUE
> 22/03/2006 - should be TRUE
> 22/03/2006 - should be TRUE
> 16/06/2006
> 22/11/2004
> 23/12/2004
> 23/12/2004
>
> Thanks

[Dan]

Thanks

Was able to replace with

=IF(($E14:$E24<TODAY())*($E14:$E24>TODAY()-21))


"JMB" wrote:

> AND/OR do not work with arrays.
>
> =(E4:E50<TODAY())+(E4:E50>TODAY()-21)=2
>
>
> "Dan" wrote:
>
> > Trying to use the AND function in an array but the response is always FALSE.
> >
> > Looking for responses between yesterday and 21 days ago.
> > Equation: AND($E40:$E50<TODAY(),$E40:$E50>TODAY()-21)
> >
> > I am selecting a range of cells F40:F50 before entering in the above
> > equation but each value is "FALSE"
> >
> > Data in E
> > 09/11/2005
> > 19/12/2005
> > 11/01/2006
> > 08/03/2006 - should be TRUE
> > 12/03/2006 - should be TRUE
> > 22/03/2006 - should be TRUE
> > 22/03/2006 - should be TRUE
> > 16/06/2006
> > 22/11/2004
> > 23/12/2004
> > 23/12/2004
> >
> > Thanks