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;I F(WEEKDAY(DATE(jaar;1;1);*1)=1;DATE(jaar;1;1)+1;(D ATE(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;B 4+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?
--
arjen
------------------------------------------------------------------------
arjen's Profile:
http://www.excelforum.com/member.php...o&userid=34484
View this thread:
http://www.excelforum.com/showthread...hreadid=542447