ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   create calendar with only M-F and add multiple repeating events (https://www.excelbanter.com/excel-discussion-misc-queries/181034-create-calendar-only-m-f-add-multiple-repeating-events.html)

JohnP

create calendar with only M-F and add multiple repeating events
 
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[_2_]

create calendar with only M-F and add multiple repeating events
 
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/te...s/default.aspx

"johnp" wrote in message
...
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




All times are GMT +1. The time now is 01:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com