create calendar with only M-F and add multiple repeating events

[johnp]

Excell 2002.
I want to create an office task calendar. The tasks would be recurring
events. The recurrent rate would be based upon the number of people who can
do the task. There would be three different tasks, each with its own rate of
recurrence. I want to create a work week calendar that only contains monday
through friday, as I've found trying to work with the inclusion of saturday
and sunday really reeks havoc when trying to coordinate a recurrent event
based on a five day week into a seven day week. Eliminating the weekends in
the calculation would seem to simplify things.

The format of the calendar should be easily read by workers in cubicles.
And, hopefully, the recurring event need only be entered once and maybe
easily edited if need be.



--johnp

 

[Cimjet]

Hi John
Have a look at this website, you should be able to find something you can
use and modify to your needs.
If you need held with functions or formulas just post again, someone will
gladly help you.
HTH
Cimjet
http://office.microsoft.com/en-us/templates/default.aspx