Count Saturdays in a List
it looks you're aware of entering an array formula
lets see another idea maybe something like this
=SUM(--(WEEKDAY(A1:A20)=7))
hit ctrl-shft-ent..
--
*****
birds of the same feather flock together..
"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!
|