Y
YanYan
Each employee has a different schedule. For each employee I have created a
grid that summarizes their schedule, for example, employee A's grid reads:
1st Week Mon Tue Wed Thur Fri
of the month work work off meeting work
2nd Week Mon Tue Wed Thur Fri
of the month work off off work work
3rd Week etc. etc. etc. etc.
of the month
To create my monthly work calendars, I look at the employees grids and
manualy enter the information into a calendar. I have to create an individual
calendar for each employee every month. I dont know of a formula that would
automaticaly take my information from the grids and plug it into the
calendar, my problem is that for example in November, the first Tuesday of
the month and the first Monday of the month fall on different weeks (week 1
and week 2). Is there a formula or anything that will help me from manual
entering the data?
grid that summarizes their schedule, for example, employee A's grid reads:
1st Week Mon Tue Wed Thur Fri
of the month work work off meeting work
2nd Week Mon Tue Wed Thur Fri
of the month work off off work work
3rd Week etc. etc. etc. etc.
of the month
To create my monthly work calendars, I look at the employees grids and
manualy enter the information into a calendar. I have to create an individual
calendar for each employee every month. I dont know of a formula that would
automaticaly take my information from the grids and plug it into the
calendar, my problem is that for example in November, the first Tuesday of
the month and the first Monday of the month fall on different weeks (week 1
and week 2). Is there a formula or anything that will help me from manual
entering the data?