Thread: AND array
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dan
 
Posts: n/a
Default 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