Work Days

[NeedHelp]

How do I calculate the number of days between 2 dates- looking for work days
only-excluded weekends and holidays?

 

[Gina Whipp]

NeedHelp,

Have a look here... http://www.mvps.org/access/datetime/date0006.htm

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Arvin Meyer [MVP]]

How do I calculate the number of days between 2 dates- looking for work
days
only-excluded weekends and holidays?

How do I calculate the number of days between 2 dates- looking for work
days
only-excluded weekends and holidays?

The second function on this page should work:

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

you might also be interested in:

http://www.datastrat.com/Code/GetBusinessDay.txt

--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Disclaimer: Any code or opinions are offered here as is. Some of that
code has been well tested for number of years. Some of it is untested
"aircode" typed directly into the post. Some may be code from other
authors. Some of the products recommended have been purchased and
used by the author. Others have been furnished by their manufacturers.
Still others have not been personally tested, but have been
recommended by others whom this author respects.

 

[Jacqueline Langlois]

NeedHelp,

Have a look here... http://www.mvps.org/access/datetime/date0006.htm

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[ingridvorst]

 

[(PeteCresswell)]

Per NeedHelp:

How do I calculate the number of days between 2 dates- looking for work days
only-excluded weekends and holidays?

Somebody will need to maintain a table for the holidays:
different locales, different organizations, different purposes
(i.e. banking, stock trading, working) ==> different holidays.