If you must have the data in Workspace, you may need to give up on the idea of have days as columns...
OR create 31 rolling date ranges (yesterday, 2 days ago, 3 days ago, 4 days ago.... etc) and use those as columns? This is the only way I can think to ensure that the dates will properly roll......