A
acw
Shayta
Based on your descripton below and a couple of
modifications, I've come up with the following:
Row 2 has the dates, starting in A2, F2, K2.... The date
is in the format 1/1/03, 1/2/03 and formatted as below.
Row 3 has the numbers 207,103,104, 302, 306 in A3 - E3 and
then repeated.
I have put data in cell C30.
In A1 I have put in the date 27/01/03. In B1 I have put
in 104.
From this, the result you want would be false as C30 has
data.
In cell C1 put in the formula
=ISBLANK(OFFSET(A3,DAY(A1),MATCH(B1,A3:E3,0)+MATCH
(DATEVALUE("1/"&MONTH(A1)&"/"&YEAR(A1)),2:2,0)-2))
This will test the cell C30 and the answer is false.
If you have any questions on this, come back to the email
address provided.
Tony
Based on your descripton below and a couple of
modifications, I've come up with the following:
Row 2 has the dates, starting in A2, F2, K2.... The date
is in the format 1/1/03, 1/2/03 and formatted as below.
Row 3 has the numbers 207,103,104, 302, 306 in A3 - E3 and
then repeated.
I have put data in cell C30.
In A1 I have put in the date 27/01/03. In B1 I have put
in 104.
From this, the result you want would be false as C30 has
data.
In cell C1 put in the formula
=ISBLANK(OFFSET(A3,DAY(A1),MATCH(B1,A3:E3,0)+MATCH
(DATEVALUE("1/"&MONTH(A1)&"/"&YEAR(A1)),2:2,0)-2))
This will test the cell C30 and the answer is false.
If you have any questions on this, come back to the email
address provided.
Tony