Another one:

A1 = any date in the month of interest

=4+(DAY(A1-DAY(A1)+35)<WEEKDAY(A1-DAY(A1)-DOW))

Where DOW = Monday = 1 to Sunday = 7

--
Biff
Microsoft Excel MVP


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