• This calendar table might also help you out

    http://www.sqlservercentral.com/scripts/Date/68389/