PDA

View Full Version : [SOLVED:] How to calculate a date 6 days into the future excluding a table of dates?



sdhruv
06-04-2015, 07:55 PM
I am using VBA in access 2007 to find a date 6 days into the future but I want to make it skip a table of holidays called tblHolidays with a column called HolidayDate. I have a seven-day work week hence I do not need to skip the weekends for which I found a lot of different types of code which confused me thoroughly. If I could get some help in this I would be eternally grateful. Thank you.