See this link.
http://www.sqlservercentral.com/scripts/Date/68389/
A calendar table will probably work well for this use.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/