=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