Need Turnaround Query to exclude weekends

[Maven4Champ]

In my database I have a Date Received and a Date Completed for each request that I receive. My original query basically said Expr1:[Completed]-[Received] to give me X number of days. My problem is I only need to count business days and not include weekends.

Is there a formula to exclude weekends from the calculation?

 

[CT Witter]

Try using this function from the MS KB Article # 210562-How to Find Number of Working Days Between Two Dates
http://support.microsoft.com/?kbid=210562

Then you can use in query as Expr1:Work_Days([Received],[Completed])

Note this doesn't incorporate holidays. If you need to use holidays, see
http://www.mvps.org/access/datetime/date0006.htm

This sample db shows how to use a table of holidays.



HTH,
CT