Hi,
I'm on my way to create a Calender in Excel and
there is something that bothers me.
For some reasons I have to set up the Data entered in
one Column in a special way, that means I have to enter
my Data in the following scheme:

Repeat infinity {
Repeat 3 {
Night [5 Days]
Weekend
}
Reapeat 3 {
Late [5 Days]
Weekend
Early [5 Days]
Weekend
}

}

So I have to determine the first day(night) of a night-block
and have to care about the jump to the next month.
How can I achieve the first thing?
The Second is the problem to jump from one Column to another.
The highlighting of a certain time is of no problem, as I've
done this already.

e. g.:

a1: Date ;B1: [N/L/E]; C1: Special; d1: Date[next Month]; e1: [N/L/E] ..


Please help me, somebody
M