With any date in cell A1...

The general formula is:

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

DOW is a weekday number from 1 to 7. Whe

1 = Monday
2 = Tuesday
3 = Wednesday
4 = Thursday
5 = Friday
6 = Saturday
7 = Sunday

So, to count how many Friday's are in January 2010:

A1 = some date in January 2010 like 1/1/2010

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

--
Biff
Microsoft Excel MVP


"Paris2459" wrote in message
...
I need to find out how many of a certain day are in a given month.
Ex: I need to know how many Thursdays are in each month for a calendar
year
so I would need to find how many Thursdays are in Jan, Feb, Mar etc