Count Saturdays in a List
Try something like this:
With dates in A1:A100
This formula counts the number of Saturdays
=SUMPRODUCT(--(WEEKDAY(A1:A100)=7))
Or....if some of the cells may be blank:
=SUMPRODUCT(--((A1:A1000)*(WEEKDAY(A1:A100)=7)))
Does that help?
***********
Regards,
Ron
XL2002, WinXP
"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!
|