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 |
All times are GMT +1. The time now is 07:40 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com