You could create a UDF that accepts two dates (and the day of week you want to count between the two dates) and returns the number of the count. You then use the UDF in your query.