MS Access - Working days between 2 dates

Question

How do I calculate working days between dates in a access query

Answer 1

You'll also find examples in Workdays.zip in my public databases folder at:

https://onedrive.live.com/?cid=44CC60D7FEA42912&id=44CC60D7FEA42912!169

If you have difficulty opening the link copy its text (NB, not the link location) and paste it into your browser's address bar.

This little demo file illustrates means of doing so, optionally taking account of public or concessionary holidays, either in a single country or in the context of multiple countries with differing holiday dates (as in the constituent countries of the UK).  It also allows for custom working weeks other than the standard Monday to Friday.

Answer 2

This page:

http://access.mvps.org/access/datetime/date0012.htm

has several functions to do Work Day arithmetic including

dhCountWorkdaysAWhich Counts the business days (not counting weekends/holidays) in
    ' a given date range.

Answer 3

See:

http://access.mvps.org/access/datetime/date0006.htm

http://access.mvps.org/access/datetime/date0012.htm