Thread: search for dates set by a formula

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?

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;IF(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;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?
>
>
> --
> arjen
> ------------------------------------------------------------------------
> arjen's Profile: http://www.excelforum.com/member.php...o&userid=34484
> View this thread: http://www.excelforum.com/showthread...hreadid=542447
>
>