I'm trying to create a to do list schedule like spreadsheet that would show only the data presented for the current week.
I've been having some difficulty figuring out how to display the data of columns for only this week and delete and add columns as days go by. The spreadsheet would display the current date in B1 (3/17/14) Current Day in B2 (Monday) and follow the next six days (to display 3/23/14 in H1 and Sunday in H2). This data would then shift tomorrow to display the new current date in B1 and end of week date in H1 (3/18/14 and 3/24/14) and the corresponding days in B2 and H2 (Tuesday and Monday). The entire columns of the previous B and current H would be deleted and added and everything else would shift over.
I haven't the slightest idea how dates work in Google Scripts and could use any help I can get.