Try this:-

=SUM(IF(WEEKDAY(A1-1+ROW(INDIRECT("1:"&TRUNC(B1-A1)+1)))=C1,1,0))

A1= Start date
B1 = End date
C1 = day of week you want 1=Sun - 7 = Sat
It's an array so Ctrl+Shift+enter

Mike

"Chuck M" wrote:

Hi all,
I need to determine the # of Saturdays in a given month. Can anyone help?
--
TIA
Chuck M.