Counting the Number of Working Days in Access 2007. Summary: Learn how to calculate the number of working days between two dates in Microsoft Office Access 2007. Sal Ricciardi, Microsoft Corporation January 2009 Applies to: 2007 Microsoft Office system, Microsoft Office Access 2007 Contents In your business, you may have to calculate the number of working days between two dates. Calculating a future Workday Date - Microsoft: Access Modules (VBA Coding) FAQ. The function to calculate the working days between two given dates has been posted for over two years.
Several threads have inquired about finding the next working day (N days in the future of a given date. I posted this some time ago in a specific thread, and decided it was reasonable to post as a faq. The routine is written specifically for DAO access to the table of holidays. For those who are not sure, the field HOLIDATE is of date type, and HOLINAME is of string type. The example is (obviously) my version of some days of interest, and doesn't have any rational basis.
Date/Time: Doing WorkDay Math in VBA. VBA and Access do not provide any support for working with the typical workdays (Monday through Friday).
VBA Developers Handbook (Sybex) contains several functions that provide information about the next and previous workday, and finding the first and last workday in a month. To deal with Holidays, the original SkipHolidays function accepted a reference to a recordset containing all the dates that you would want these functions to skip over.