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

where DoW is the day number to test, 1 Sun, 2 Mon

--
HTH

Bob Phillips

(replace somewhere in email address with googlemail if mailing direct)

"Rossta" wrote in message
...
I'm trying to get Excel to calculate the number of Mondays, Tuesdays, etc
in
a given month but I haven't found a function that addresses this task.
Any
ideas?