Date Value Error

I have this data table that I want numbers from basically each day of the month to give me data for specific things. Everything works and it is all okay, except when i try to set the date to anything...