Wrox Programmer Forums
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old April 26th, 2005, 02:15 PM
Registered User
 
Join Date: Apr 2005
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default Access Workdays calculation

Hi,

I am working in Access and I want to do a calculation of Date 2 - Date 1. However, I do not want to count weekends or holidays in the calculation. How do you type in the calculation to exclude those weekends and holidays?

Thanks

Doug

 
Old April 26th, 2005, 02:19 PM
Friend of Wrox
 
Join Date: Oct 2004
Posts: 564
Thanks: 0
Thanked 4 Times in 4 Posts
Default

Excel has a function called NETWORKDAYS, which takes 2 dates, exludes weekends, and you can pass it a list of holidays to exclude as well. I would check and see if Access has access to this function. It has saved me a whole lot of work in the past.

Hope that helps

Mike

Mike
EchoVue.com





Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculation in access ashik112 Access 1 February 26th, 2007 08:38 AM
Need Help creating calculation in Access karen.houston Access 2 August 11th, 2006 06:45 AM
Workdays Using DateDiff iancrabtree Access VBA 7 November 26th, 2005 09:46 PM
Calculate Workdays minus holidays woodan Access 1 February 11th, 2004 04:17 PM
Field Calculation Upgrade to VBA from Access Basic Pavesa Access VBA 2 December 23rd, 2003 12:24 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.