Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
YanYan
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automaticaly create montly calendars for 30 employees YanYan Excel Discussion (Misc queries) 1 November 15th 05 01:01 AM
elseif formula macrodummy Excel Discussion (Misc queries) 1 October 7th 05 01:43 PM
loop trough e-mail address list to send task lists with outlook Paul. Excel Discussion (Misc queries) 2 April 14th 05 11:48 AM
Number of employees in the appropriate time column Steve Excel Worksheet Functions 8 March 10th 05 10:55 PM
How do I create individual pie charts for 99 different employees? K. Biscello Charts and Charting in Excel 0 February 10th 05 08:35 PM


All times are GMT +1. The time now is 07:20 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"