You need a calendar table. Build one, stick it in a dba database, query it to run. You could even add flags for days and holidays. Makes life much simpler.
http://www.sqlservercentral.com/articles/T-SQL/70482/