Hello and thank you all in advance.

Is there a way to insert a new column into a spreadsheet every day and enter the new date in the first column, then move the rest down?

So for instance i have my heading in rows 1 and 2. then freeze panes and my date for each day in columns 3, 4, 5 and so on. What i want it to do is every day when i open it, it moves all the data down one row and start a new row at line 3 for that days data.
Is there a nifty bit of code that could do this please?