Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Problem with Vlookup array selection | Excel Worksheet Functions | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
Return Array with Array | Excel Worksheet Functions | |||
Formula to list unique values | Excel Worksheet Functions | |||
VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) |