PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Discussion search for dates set by a formula

Reply

search for dates set by a formula
 
Thread Tools Rate Thread
Old 12-05-2006, 03:52 PM   #1
Arjen
Guest
 
Posts: n/a
Default 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;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?
  Reply With Quote
Reply

Archive


Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off