Hi all,

I have a formula that filters out the weekend dates. The formula is:
=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:
=IF((WEEKDAY(B4)+1)=7;B4+3;(IF((WEEKDAY(B4)+1)=1;B4+2;B4+1)))
a third cell contains the 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?