Whatever the issue is keeps pointing to the "Result = Result + MinDay" of this section:
Code:
Do Until StDateD = EnDateD
'If the date is not a saterday or a sunday we add one day.
If (Weekday(StDateD) > 1) And (Weekday(StDateD) < 7) Then
Result = Result + MinDay
'Check for the holiday. If the date is a holiday, then we remove one day
If Not IsNull(DLookup("[HolDate]", "Holidays", "[HolDate] = #" & Int(StDateD) & "#")) Then
Result = Result - MinDay
End If
I am also getting a Runtime Error '6': Overflow and on debugging it highlights:
Result = Result + MinDay