Class schedulee issues

[teomi]

Hi all,

I am trying to generate a date schedule of a collection of classes.
the first class starts in a defined date and all of the classes follow linearly.
Each class has a unique length that I already defined in a column.

the struggle that I am having is because classes are given only on Mon-Thursday, so no classes on Fri and the weekend.

Can I change the week definition somehow or is there a formula that will consider a week only 4 days and adjust the dates accordingly?

Thanks in advance,
Eitan

[arthurbr]

Hi and welcome to the board
To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

[teomi]

Hi there, thanks for your reply.
I am attaching a dummy here.
It illustrates where I am at, what I need to achieve and where the problems are.

Please let me know if you need more info. It may not be clear when trying to understand it from text..

Thanks in advance,
Eitan