Number of Work days

  • Thread starter Thread starter Manuel Banuelos
  • Start date Start date
M

Manuel Banuelos

I have 2 date fields: dateIn & dateOut.
Can some one please show me how to get the total of "Work Days" (not including Sat. nor Sun.) to do so?
 
Take a look at the article at
http://support.microsoft.com/default.aspx?scid=kb;en-us;210562 for one
approach. Be aware, as the article states, it does *not* account for
holidays.

The article at http://www.mvps.org/access/datetime/date0006.htm shows both a
non-holiday and a holiday version.

Good luck.

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Useful Metric Conversion #17 of 19: 1 billion billion picolos = 1 gigolo
Miscellaneous Access and VB "stuff" at www.ScoBiz.com


I have 2 date fields: dateIn & dateOut.
Can some one please show me how to get the total of "Work Days" (not
including Sat. nor Sun.) to do so?
 
You are the greatest, this article helps a lot, maybe I will consider
Denver, been there its beautiful, love the airport.
 
See! This is just a *tiny* fraction of the great stuff you will learn! :-)

Beautiful place it is.

However, I'm not sure I share you enthusiasm for the airport. :-)

In the mean time, pick up a copy of "Beginning Access 2002 VBA" (The 2003
version won't be out for a few months.) from Wrox.

Good luck.

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Useful Metric Conversion #17 of 19: 1 billion billion picolos = 1 gigolo
Miscellaneous Access and VB "stuff" at www.ScoBiz.com
 
Back
Top