I have been using the following code (and also a table that houses the holidays) to calculate turnaround time in my database. It works great, and properly excludes holidays and weekends.  I would like to have it so that if something is turned around on the same day it calculates that TAT as 0. Currently it is counting it as 1 day. I tried editing the +1 to -1 in the code below but all that did was continuously crash everything out. Here is the code:

Function WorkingDays(ByVal fromDate As Date, ByVal toDate As Date) As Long

If IsNull(fromDate) Or IsNull(toDate) Then
            WorkingDays = 0
            Exit Function
        End If

    While fromDate <= toDate
        Select Case True
            Case Weekday(fromDate, vbMonday) > 5
            Case DCount("*", "Holidays", "Holiday = #" & Format(fromDate, "mm/dd/yyyy") & "#") > 0
            Case Else: WorkingDays = WorkingDays + 1
        End Select
        fromDate = fromDate + 1
    Wend
End Function