View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Handyy
 
Posts: n/a
Default Workday function including sat, excluding sun


Hi,

I'm trying to create a function which would calculate estimated
kilometers driven. Our trucks will stop only for sundays so there comes
my WORKDAY-function problem.

If I have example dates:
1.1.2006 - 31.1.2006 = 26 truck workdays

How can I get that result with workdays function, saturdays included
but bank holidays excluded?

Thanks in advance :)


--
Handyy
------------------------------------------------------------------------
Handyy's Profile: http://www.excelforum.com/member.php...o&userid=30958
View this thread: http://www.excelforum.com/showthread...hreadid=515264