Hi,

I really need help with a formula. Hope some of you could help me out.

In Sheet 1 i have a list of project categories in column A. In column B i have tasks within the different projects.
In column C I have the start week of this task and in column D i have the end week of the task.

In sheet 2 I would like to make a list of all tasks happening the actual week.
I then need both project in column A and the task in column B.

Hope this was clear.


Do anyone know the magic formula?

All the best!

TB.