I don't really understand what you're trying to achieve here.

if you have all the dates down in column A fro Jan1 thro Dec31, then you can
easily in B determine the day of week.
you should also be able to figure out the series of lates and early's

are you having three weeks of nights then a set of late week early week?

ie one series looks like this:

NwNwNwLwEwLwEwLwEwLw

you can use a formula to count the N's, L's or E's so that if N or E sum to
3, the next letter gets chosen. This can all be done with formula, though
coding would be trivial IF we get a clear idea of what you expect as a
result




"Michael Rühling" wrote in message
...
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