search for dates set by a formula

[arjen]

Hi all,

I have a formula that filters out the weekend dates. The formula is:

Code:
--------------------

=IF(WEEKDAY(DATE(jaar;1;1);1)=7;DATE(jaar;1;1)+2;IF(WEEKDAY(DATE(jaar;1;1);*1)=1;DATE(jaar;1;1)+1;(DATE(jaar;1;1))))

--------------------

the named value "jaar" is a defined named value pointing to a different

cell that contains the value "2006"


The next cells contains the following codes:

Code:
--------------------

=IF((WEEKDAY(B4)+1)=7;B4+3;(IF((WEEKDAY(B4)+1)=1;B4+2;B4+1)))

--------------------



a third cell contains the code:

Code:
--------------------

=b4

--------------------

now I want to search for the row that contains the same date as in the

third cell. (I know this is row 4 here, but I have a lot of dates that

has to be searched for).
Whatever I have tried, it won't return the number of the row, as it
cannot find the date.


Any ideas?

 

[Guest]

Look at Excel help on the Match worksheet function.