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


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?



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

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



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.