• Home
 · 
• Math/Dates
 · 
• RemoveWeekEnds

RemoveWeekEnds

Returns number of business days from a start date and total number of days. There are more pieces coming. Building a routine that calculates holidays and weekends to tell you strictly business days.

Inputs
strStartDate and totalsdays

Returns
total number of business days

Rate RemoveWeekEnds

• 1
• 2
• 3
• 4
• 5

(3(3 Vote))

Public Function RemoveWeekends(strStartDate As String, intNumberOfDays) As Integer
  Dim i As Integer
  
  For i = 0 To intNumberOfDays
    Select Case Weekday(DateAdd("d", i, CDate(strStartDate)))
      Case vbSaturday, vbSunday
        intNumberOfDays = intNumberOfDays - 1
    End Select
  Next i
  RemoveWeekends = intNumberOfDays
End Function