Pull data from different column based on current date

raisy27

I am looking to use the sheet below that was created that has hours of projects by week. Each project is on its own line

I am looking to return all hours from this sheet for the "current week" this will obviously change based on the date.

I think there isn't a way to dynamically change the column referenced. Can you help me think of another way to sum all these numbers ONLY for the current week?

Darren Mullen

@raisy27

Since you have the row with Week 1, Week 2 ….. Week N, you could run a match() on that column to look for the current week. Then you'd know the column index in the sheet of the current week.

With the column index, you could then match the correct row by column.

It would take some Index()Match() formula work, that that's how you'd do it. Match not only the row index, but also the column.