One way to do this is to create a Calendar or Date table.

Take a look at: http://weblogs.sqlteam.com/dang/archive/2010/07/19/calendar-table-and-datetime-functions.aspx

HTH,

Rob