Chris,

You say that today's date is not relevant.... what date is relevant?

AQ3 is 01 Dec 2009.

170 days before 01 Dec 2009 is 14 Jun 2009. Let's say that X3 is "VACANT"

If you are looking at the workbook on 13 Jun 2009 (171 days before 01 Dec
2009), what do you want to see in AR3? TRUE - or - FALSE?

If you are looking at the workbook on 14 Jun 2009 (Exactly 170 days before
01 Dec 2009), what do you want to see in AR3? TRUE - or - FALSE?

If you are looking at the workbook on 15 Jun 2009 (169 days before 01 Dec
2009), what do you want to see in AR3? TRUE - or - FALSE?

WHEN do you actually want to see TRUE in cell AR3?

Bernie


"Chris" wrote in message
...
Hi Bernie, Oops, I am sorry I have not made myself very clear -
sometimes it is dificult to explain what you want

when a picture speaks a thousand words. Here is an example: (please
note that today's date is not used in the

equation). We need the formula to be in column AR for the following
example:

In column X at cell X3 is the text: "VACANT". In column AQ at cell AQ3
is the date: 01 Dec 09. We need to know 170

days out from the date showing in column AQ (which in this example is:
01 Dec 09), that the corresponding value in

cell X3 contains the text: "VACANT" (which for this example it does).
Thus, the corresponding cell at AR3 (using

your formula) would be popluated with TRUE.

In column X at cell X4 is the text: "FILLED". In column AQ at cell AQ4
is the date: 05 Dec 09. We need to know 170

days out from the date showing in column AQ (which in this example is:
05 Dec 09), that the corresponding value in

cell X4 contains the text: "FILLED" (which for this example it does).
Thus, the corresponding cell at AR4 (using

your formula) would be popluated with FALSE.

In column X at cell X5 is the text: "VACANT". In column AQ at cell AQ5
is the date: 12 Dec 09. We need to know 170

days out from the date showing in column AQ (which in this example is:
12 Dec 09), that the corresponding value in

cell X5 contains the text: "VACANT" (which for this example it does).
Thus, the corresponding cell at AR5 (using

your formula) would be popluated with TRUE.

Does this example help clear things up?

Kind regards,

Chris.



*** Sent via Developersdex http://www.developersdex.com ***