A
Arjen
Hi all,
I have a formula that filters out the weekend dates. The formula is:
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:
a third cell contains the code:
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?
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))))
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
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?