Ger
03-27-2008, 01:13 AM
Hi,
the formula =SOMPRODUCT(--(1+INTEGER(($A$1:$G$2-(DATUM(JAAR($A$1:$G$2);1;2)-WEEKDAG(DATUM(JAAR($A$1:$G$2);1;1))))/7)=A10)) works fine if all cells are filled with dates. But not all cells are filled yet and this formula gives empty cells the date 1-1-1900.
Can someone help me how to get round this problem.
Thanks
Ger
the formula =SOMPRODUCT(--(1+INTEGER(($A$1:$G$2-(DATUM(JAAR($A$1:$G$2);1;2)-WEEKDAG(DATUM(JAAR($A$1:$G$2);1;1))))/7)=A10)) works fine if all cells are filled with dates. But not all cells are filled yet and this formula gives empty cells the date 1-1-1900.
Can someone help me how to get round this problem.
Thanks
Ger