Determine 3rd Friday of each month
Given:


Friday is called "Friday" 
The 3rd Friday of the month will always
fall from 15th-21st of the month

select thedate
from yourtable
where datename(weekday, thedate) = 'Friday'
and datepart(day, thedate)&gt;=15 and datepart(day, thedate)&lt;=21;



You could also use weekday with datepart(), but it's more readable with a name IMO. String comparisons will obviously be slower though.