Query to display day in sp

Question

In My project i have to display holiday lists of company

i want to create storeprocedure that return specific days of the period ,as parameter i am passing periods(from and to date) and day of the week ,and specific day.

example : 

for the period 1-june-2013  to 30-june-2013 i need to get all sundays when i passed sunday as parameter