I have the following queri statement to exclude saturday and sunday:
Code:
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