4

I'm looking to create a total data sheet that gives me the total spreadsheet for the current week, next week and previous week, from data from another worksheet. The problem that I have is that the dates are the column names, does anyone have any suggestions on how to accomplish this. Currently I just highlight the columns that to use and the people but is there another way to do this so I'm not creating new formulas every week.

Industry
Department

Comments

Andree_Stara

Hi Kari,

Would it work if we structured the sheet with the dates on the rows instead of the columns? 

Can you show more of the sheets so I can see the structure?

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, [email protected])

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

I generally follow something very similar to Andree's suggestion. Depending on the amount of data and the use of that data, I will set it up two different ways.

.

1. Make everything a date column, put the date in the top row, then reference row 1 in all of my formulas.

.

2. (Most often used for me) is to use three additional rows. One for day, one for month, one for year. I can then reference the cell in the same column on the appropriate row for whatever portion of the date I am trying to use as my criteria.

.

Some of my other sheets are also broken down by week number and year.