Solved: count dates in a week (continue)

[Ger]

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

[Bob Phillips]

=SOMPRODUCT(--($A$1:$G$2<>""),--(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))

[Ger]

Thanks a lot again.

Ger :thumb