Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Returning contents of a cell
I have an array of dates and need to determine if it is within a given range
from today. Potential dates a A B I Oranges 19/12/2005 =today() Apples 11/01/2006 Pears 08/03/2006 Bananas 22/03/2006 Tomatos 16/06/2006 Grapes 22/11/2004 The formula I have is =IF((I1-1)B1:B6, B1:B6(I1-21)). Now if the equation is TRUE then I want the contects of that cell and row returned. Based on this equation I want the following response: F G Pears 08/03/2006 Bananas 22/03/2006 Thanks Dan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
separating numbers and letters from alphanumeric cell contents | Excel Worksheet Functions | |||
Conversion of Cell Contents into a Functional Worksheet name ? | Excel Worksheet Functions | |||
Adding contents of one cell to a range of cells. | Excel Worksheet Functions | |||
Returning a Value to a Cell Based on a Range of Uncertain Size | Excel Worksheet Functions |