I am trying to track the last 30 days people worked overtime. I want to set
up my spreadsheet with the columns as the last 30 days and the rolls as
individual employees. If a person works today I enter the number of hours
worked under todays date column. Thrity days from now I will delete the
column form today. This is where I need help. When I drop (or delete) the
column that is 30 days old, I need to have the new column come on to the
spredsheet with the new (todays) date. I need to see the last 30 days of
information and to be able to pull that information like the number of days
worked and the number of hours worked.

PS. I am a beginner in excel so please keep replies simple to understand.