And one mo

=SUM(IF(MOD(R,7),,1))

Array entered. Where R is a range name for your data.

--
Thanks,
Shane Devenshire


"T. Valko" wrote:

=SUMPRODUCT(--(WEEKDAY(A1:A20)6))

Biff

"H" wrote in message
...
Hi,

I need to count the number of Saturdays in an array of dates. I used the
following approach, which didn't work. Does anyone have another idea?

{=SUM(IF((WEEKDAY(array1,2)=7),1,0))}

Thanks!