| 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 | |||
Linear Mode
