Calculating Working Days In a Specified Period

[tbohon]

Am aware of how to do days between dates calculations but the boss wants to calculate (in Access 2003) just the number of working days - defined as Monday through Friday - in a given period of time. I have no clue - have tried using the first day's day of the week but it got really messy real fast.

Any ideas?

Tnx.

Tom

"My mind is like a steel whatchamacallit ...

 

[SgtJarrow]

If you do a search here on the site, concentrating on FAQs, you will find a couple examples of what you are seeking to do. One such I created is faq705-4531. Of course, these will depend on your Access coding knowledge to accomplish. But these should give you good starting points. If you still need help after trying, feel free to post back, describing what you have tried and what is not working. Good Luck.

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+, CHDP
VB/Access Programmer

 

[PHV]

The M$ answer:

http://support.microsoft.com/?kbid=288194

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886