function required

[faeiz2]

Hi all,

I prepare shift schedule for my staff, how do I simplified the process of
copy and paste by using a function. Let say I change the first day of the
month to second day shift and I want the rest to follow the same patern
NNOOOODDNNOOOODDNN and so on, and if I change the first day to N, I want the
rest to follow the same patern.


My sample:
date: 1 2 3 4 5 6 7 8 9 10 11 12
...........31
shift: d d n n d d n
n ..........

d = day shift
n = night shift
blank = off day


tq.

 

[Bob Phillips]

Bit tricky, as you don't tell us what determines if it is D,N or blank. And
what is O?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)