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

or

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

HTH
Kostis Vezerides


H wrote:
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!