I did sth like below to count Mondays in a month where the month is calculated from the date passed as parameter to the function:

CREATE FUNCTION fn_GetNumMondaysInMonth (@Date datetime) RETURNS...