thats okey mama for a non-workday on saturday, yet the schedule of my boss
includes the overtime of saturdays, we are a private company with many
subcontractors...my boss has to feed the schedule to our subcontractor, and
penalty will be based on his bossy schedule...
the problem is that i was surprised by his need, to give the schedule to all
subcon on Jan.2,2007...
please help with a little more shot.
he will either specify the end_date of an activity or either a start_date of
the activity, and the unknown date will be based on the quoted workdays of
the subcontractors...its a really messy and muddy work for me, with a boss
that so strict down to to a single cent and love to see changing colors.

i believe there is a safebag of formula that can suit my boss pushy need.

been dribled3

"Teethless mama" wrote:

Let's say

Start day in A1 =12/1/2006
Numer of workdays in A2 =29 (29 work days)
Holidays in A3:A5 (X-mas, boxing day, New year)

Formula in A7 =WORKDAY(A1,A2,A3:A5)

Adjust your value and your range to suit


"dribler2" wrote:

i may be in deep trouble now,

can someone with kind heart share me a formula of something like this

=countworkday(Start_date:End_date, -weekday{1,7}, -holiday list)

i lost my touch with worksheet functions, hope u can help me with this pushy
question from my big boss...

whoosh sorry for asking a lot, just one shot i will explore it, thanks
been dribled2