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]

Thanks

Was able to replace with

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