Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Individual calendars for 30 employees
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automaticaly create montly calendars for 30 employees | Excel Discussion (Misc queries) | |||
elseif formula | Excel Discussion (Misc queries) | |||
loop trough e-mail address list to send task lists with outlook | Excel Discussion (Misc queries) | |||
Number of employees in the appropriate time column | Excel Worksheet Functions | |||
How do I create individual pie charts for 99 different employees? | Charts and Charting in Excel |