Question:

The excel form my boss uses to count days in a course is detailed an
overcomplicted. I would rather use a one sheet workbook but he is boun
and determined to use it.

We have to manually put in the days off during a week, and then coun
all the days NOT off to come up with a graduation date, which is 5
days down the pipe.

Is there a way to:

1. say start date is thursday so it will count 2 days and then auto pu
in two days for the weekend, then count 5 for the work week and put i
two days for the next weekend and so forth until the # of work days
the course length of 52 days?? I have piddled with code and got n
where.

2. while doing the above when it gets to the weekend put in the wor
"off" or something in those blocks.

I am *SO* stuck its not funny.

Thanks!

Jo

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"joederr" wrote in message
...

Question:

The excel form my boss uses to count days in a course is detailed and
overcomplicted. I would rather use a one sheet workbook but he is bound
and determined to use it.

We have to manually put in the days off during a week, and then count
all the days NOT off to come up with a graduation date, which is 52
days down the pipe.

Is there a way to:

1. say start date is thursday so it will count 2 days and then auto put
in two days for the weekend, then count 5 for the work week and put in
two days for the next weekend and so forth until the # of work days =
the course length of 52 days?? I have piddled with code and got no
where.

2. while doing the above when it gets to the weekend put in the word
"off" or something in those blocks.

I am *SO* stuck its not funny.

Thanks!

Joe


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/