Hello guys, I was wondering if there was a simple way to accomplish a task I can't seem to get working with just excel formulas.

Essentially I'm trying to create a chart that will show the availability of a classroom during a certain time period. I'll have an input chart where the user can schedule various trainings in specific classrooms and the output should block out the appropriate time period for that class length. There are various types of classes and each one has it's own length, that's what is giving me issue, I can only make it work with one length so far.

So say I've got a chart showing the previous 4 weeks and the current week up to 13 weeks out. If somone comes in and puts training X into week 3 I need that room to be occupied for 4 weeks starting the week they chose. But if they put in training Y in the top chart it need only block out 2 weeks.

Any tips would be appreciated.