Here is an article on tally tables.

http://www.sqlservercentral.com/articles/TSQL/62867/

There is code to get a list of dates between two dates using the tally table in the article.

You will then just need to filter using DATEPART to exclude Saturdays ad Sundays.

Give it a try, post here again if you have any trouble.