try this where a1 contains any date in the month desired
=SUMPRODUCT(--(WEEKDAY(A1-1+ROW($A$1:INDEX(A:A,DAY(EOMONTH(A1,0)))))=7))
or start date in a1 and end date in a2
=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(a1&":"&a2)))=7))
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Chuck M" wrote in message
...
Hi all,
I need to determine the # of Saturdays in a given month. Can anyone help?
--
TIA
Chuck M.