Calculate work days

[Guest]

I am trying to calculate the number of work days between two dates, excluding
weekends and holidays. I have the DateAddW function that successfully
excludes weekends, but it doesn't exclude holidays. How can I do both?

 

[Douglas J. Steele]

Take a look at http://www.mvps.org/access/api0012.htm at "The Access Web",
or what I had in my September, 2004 "Access Answers" column in Pinnacle
Publication's "Smart Access". You can download the column (and sample
database) for free at http://www.accessmvp.com/DJSteele/SmartAccess.html

 

[Guest]

Holidays are kind of dependant on the individual (no such thing as a standard
set of holidays)

If you had a table of `known holidays` - that way you could include bank
holidays, extra company holidays, invidual booked holidays, unexpected time
off, whatever you want to stick in it - then it would simply be a matter of...

work days = <number of days excluding weekend days> - <number of individual
holiday days in your holiday table that occure within your date range>

martin

 

[Guest]

Thank you very much. I think the information I have already re: how to
calculate work days originally came from you. Now the holiday information
will be all I need. Again - thank you very much.