Ger
03-27-2008, 07:58 AM
Hi,
again i have a [problem with counting the dates to a week. The problem is that the formula =SOMPRODUCT(--(1+INTEGER(($E$5:$M$29-(DATUM(JAAR($E$5:$M$29);1;2)-WEEKDAG(DATUM(JAAR($E$5:$M$29);1;1))))/7)=C32)) doesn't accept a reference to an other worksheet. So i give it a value (0). But now i have the problem that i cann't count the value's in the row because 0 is also a value.
See the example (column O)
Ger
:banghead:
again i have a [problem with counting the dates to a week. The problem is that the formula =SOMPRODUCT(--(1+INTEGER(($E$5:$M$29-(DATUM(JAAR($E$5:$M$29);1;2)-WEEKDAG(DATUM(JAAR($E$5:$M$29);1;1))))/7)=C32)) doesn't accept a reference to an other worksheet. So i give it a value (0). But now i have the problem that i cann't count the value's in the row because 0 is also a value.
See the example (column O)
Ger
:banghead: