search for dates set by a formula
 

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

search for dates set by a formula
 

Look at Excel help on the Match worksheet function.

--
Regards,
Tom Ogilvy


"arjen" wrote:


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