Networkdays International VBA code to deduct Public Holidays

[sajanvgs]

I seem to be lost on how to include public holidays in Network Days International VBA function? The below code works fine if no public holidays are involved but if I have some public holidays in a month how do I correct the below code?

Cells(a, 85).Value2 = Abs(WorksheetFunction.NetworkDays_Intl(.Cells(a, 72), .Cells(a, 68), 11)) - 1

 

[steve the fish]

Put the holidays in a range then consider using it like this:

Dim a As Long, hols As Range
With ActiveSheet
    a = 1
    Set hols = .Range("A1:A2")
    Cells(a, 85).Value2 = Abs(WorksheetFunction.NetworkDays_Intl(.Cells(a, 72), .Cells(a, 68), 11, hols)) - 1
End With

 

[sajanvgs]

Thanks for the help