I have developed monthly schedules for our employees for which I wrote a
macro to create the next month. The issue I have is that I had to create
excess days to calculate the different schedules. Is there an easier way to
calculate a monthly work schedule using a macro? Some employees work 6 days
on two days off 6 days on 3 days off and some work Monday thru Friday.

M T W T F S S M
T W T
Name of Employee date date date date date date date date date date date etc.
Johnson off off 8 8 8 8 8 8
off off off etc.
Smith 8 8 8 8 8 8 off
off off 8 8 etc.
Allen 8 8 8 8 8 off off

Thank you for any assistance you can offer.

You might be better off using Microsft Project. It is specifically designed
to handle schedules

Glen

"Frank" wrote in message
...
I have developed monthly schedules for our employees for which I wrote a
macro to create the next month. The issue I have is that I had to create
excess days to calculate the different schedules. Is there an easier way
to
calculate a monthly work schedule using a macro? Some employees work 6
days
on two days off 6 days on 3 days off and some work Monday thru Friday.

M T W T F S S M
T W T
Name of Employee date date date date date date date date date date date
etc.
Johnson off off 8 8 8 8 8
8
off off off etc.
Smith 8 8 8 8 8 8 off
off off 8 8 etc.
Allen 8 8 8 8 8 off off

Thank you for any assistance you can offer.