I've created a function that takes 2 dates and then should find the number of holidays between the 2 dates; the holidays are listed in a table.
Function Holidays(StartDate As Date, EndDate As Date) As Integer
Holidays = DCount("*", "tblHolidays", "([HolidayDate] <= EndDate ) AND...