Planbord

Occasional Visitor

Hi, 

 

I have made a planbord in Excel. 

 

Rows for the differt articles that need to be produced and colums per day to show the department that is working on it.

 

Now I can make an overview per day, but i also want to make it for a week. 

I just haven't figured out how. 

 

In the attachment i have selected a couple of projects so you have an idea how it looks. 

 

 

 Knipsel2.PNG

What I believe i need is a function, for IF colums contain "constructie" it needs to be showed. Per day it is simple, but when the row has multiple processes in one week, it doesn't work. 

 

Thank you in advance for your ideas.