PDA

View Full Version : Solved: count dates in a week (continue)



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

Bob Phillips
03-27-2008, 02:08 AM
=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
03-27-2008, 02:13 AM
Thanks a lot again.

Ger :thumb