Select weekend or weekday data from a table based on date param

Select weekend or weekday data from a table based on date param

How can I select data from a table based on weekday or weekend, like if
date is a weekday then select only historical weekday data from the table
& if date is a weekend then select only historical weekend data.
I have tried to do that in this way but no luck
DECLARE @MyDate DATE = '08/17/2013'
SELECT datename(dw,@MyDate)
SELECT * FROM MyTable
WHERE
datename(dw,DateColumnInTable) IN (
CASE WHEN (datename(dw,@MyDate) IN ('Saturday','Sunday')) THEN
'''Saturday'',''Sunday'''
ELSE 'Monday'',''Tuesday'',''Wednesday'',''Thursday'',''Friday'
END )
Any I can see lots of data in my table for saturday and sunday but this
query is giving me blank record set.