To do what you want (Mr cheap grass), you will need a table containing all the dates that you want. I can see no way of achieving your required results without this.
Creating such a table could be done with looping code but I think not with simple SQL.

Having the table (tblDates with field Date), you can then use SQL like :-