Thread
:
Count Saturdays in a List
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
H
external usenet poster
Posts: 57
Count Saturdays in a List
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!
Reply With Quote
H
View Public Profile
Find all posts by H