AND array
 

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:$E50TODAY()-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

AND array
 

AND/OR do not work with arrays.

=(E4:E50<TODAY())+(E4:E50TODAY()-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:$E50TODAY()-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

AND array
 

Thanks

Was able to replace with

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


"JMB" wrote:

AND/OR do not work with arrays.

=(E4:E50<TODAY())+(E4:E50TODAY()-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:$E50TODAY()-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