Working Days Excluding Saturdays, Sundays and Holidays in a given period.

[santiagj]

I want to calculate working Days Excluding Saturdays and Sundays in a given period.

I have the following queri statement to exclude saturday and sunday:

System Test Working Days LT: (
   ([Testing End Date]-[Sample Received Date])
   +(Weekday([Sample Received Date])-1)
   -(Weekday([Testing End Date])-1))
   *5/7-1
   +IIf((Weekday([Testing End Date])-1)-1>5,
      5,
      (Weekday([Testing End Date])-1))
   -IIf((Weekday([Sample Received Date])-1)>5,
      5,
      (Weekday([Sample Received Date])-1)-1)

I need add the statement to exclude Holiday. Please give me the specific code or statement. Copy and paste. Thanks

[mbizup]

<<. Please give me the apecifict code or statement. Copy and paste. >>

It's not quite that simple.

To do this, you need to define what days are holidays (these of course differ between countries, employers, etc), by setting up a table of holidays.

Read this article about calculating working days. It contains a sample that you should be able to apply to your own database.

https://msdn.microsoft.com/en-us/library/dd327646(v=office.12).aspx

[Seth Schrock]

Here is a link that describes how to list the holidays that you want excluded and also exclude the weekend: Counting the Number of Working Days

[NeoPa]

SantiagJ:
Please give me the specific code or statement. Copy and paste. Thanks

As that is specifically prohibited it's lucky this question doesn't lend itself to such a simple approach.

Perhaps it's not such a great idea to advertise that you aren't even expecting to do any of the work yourself when asking for others to spend their time helping you. I can't imagine too many experts being inspired to help you.