I have a table (tblHoliday) with a list of dates (34 records).
My form code (based on a different table) uses a For...Next Statement to count the number of weekdays between two selected dates. An embedded If statement counts only the weekdays. (Brewdog, if you're reading this it may look familiar).
I don't want to add all weekdays, though. I need to eliminate the dates listed in tblHoliday.
I am pretty sure I want to embed this in the weekday If statement so that each weekday is compared to the holiday list and not counted if it matches, but I have little idea how to reference the dates in the table.
Thanks in advance,