In a recent project, I had to build a program to calculate an end date in either business days or calendar days based on certain criteria. This solution had to work in both Excel and Access and needed to run without the use of database tables. Business Day Calculation Requirements The criteria I used to determine the definition of a business day was any non holiday weekday. … [Read more...] about Calculate Date in Business Days in VBA Without Database Tables