Attempting to create a formula/code to have excel automatically move a column over

So first thing first, new to the forum, not so new to excel, but this is my first job using it. I made a spreadsheet that will allow me to input sales of scratchers (based on the number in the stack), and compare it to the previous day's numbers, giving me a total $ amount of sales of scratchers. My question is this, is there a way to have excel move column C to column B, leaving column C clear by changing the date at the bottom of the page? I don't know how clear of an explanation this is but if it's not i can link the file. Any help would be appreciated, I work with some complete morons that cant use a calculator to add/subtract basic numbers so I need to make this sheet as easy to use as possible.

P.S. - I have attached a before and after file of what i want to happen with this. Thanks again