Counting Days

  • Thread starter Thread starter joederr
  • Start date Start date
J

joederr

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
 
--

HTH

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