How do I exclude holidays between two dates?

[Guest]

How can I exculde the number of holidays when counting the total number of
days between two dates?

 

[Rick B]

Where are your holidays defined? There are about 100 holidays on my desk
calendar. Does your Access application know which ones are valid?

Have you done a search for this? There are several samples out there to
help you build in this feature. It is not nearly as simple as your question
implies.

Rick B

 

[Paul Overway]

You would need a table listing all holidays...then query for holidays
between a given set of dates. Then subtract the number of holidays found
from the elapsed number of days.

 

[M.L. Sco Scofield]

Take a look at the second example at
http://www.mvps.org/access/datetime/date0006.htm.

There are also a bunch of date routines at
http://www.mvps.org/access/datetime/date0012.htm that might be of interest.

Good luck.

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Useful Metric Conversion #18 of 19: 8 nickels = 2 paradigms (My personal
favorite)
Miscellaneous Access and VB "stuff" at www.ScoBiz.com