another formula search, if any
 

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

another formula search, if any
 

=NETWORKDAYS(start date,end date,Hodiday range)
This function required Analysis ToolPak installed

"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

another formula search, if any
 

my mistake, sorry my mama

my boss question is re-phrased something like this
Date = (Date given + #Workday-weekday(1)-holiday list)

looking for either an end_date or start_date....
Date +#workday-sundays-holiday lists
#Workday can be "+" to find end_date
#Workday can be "-" to find start_date

I guess my boss is a cracker nut, i even ask him to directly participate
here to ease my eyes from searching in my dummy computer..

yet his the boss, my paycheck is pending, still...

thanks mama for another shot again, im sorry for the previous syntax...my
mind is in the beachfront already...

been dribled2

"Teethless mama" wrote:

=NETWORKDAYS(start date,end date,Hodiday range)
This function required Analysis ToolPak installed

"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

another formula search, if any
 

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

another formula search, if any
 

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

another formula search, if any
 

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