Looks like you need a workday formula which includes saturday as a workday.
You can adapt the WORKDAY workaround formula from here

http://www.dicks-blog.com/archives/2...-addin-part-2/

so that Saturdays are included, i.e.

=A1+IF(B1=0,0,SIGN(B1)*SMALL(IF((WEEKDAY(A1+SIGN(B 1)*(ROW(INDIRECT("1:"&ABS(B1)*10))))1)*ISNA(MATCH (A1+SIGN(B1)*(ROW(INDIRECT("1:"&ABS(B1)*10))),holi days,0)),ROW(INDIRECT("1:"&ABS(B1)*10))),ABS(B1)))

confirmed with CTRL+SHIFT+ENTER

where A1 is start date B1 is days to add (can be positive or negative) and
holidays is a defined range of holiday dates

"dribler2" wrote:

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