Monthly Schedules

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Employee Schedule with multiple options. 2
User Defined Function - reformulated repost of an earlier question 1
Calc Number of Months PER YEAR Between Dates 2
Scrabble Value calculation for Welsh words 0
Calculate total days 1
Adding up total hours worked on employee schedule using various criteria 0
How to get an end date for a schedule excluding Sundays? 5
lookup two tables 7

Back
Top