'Issue detected in WorkDays_Intl vba error

I'm working of a sub to alert deviation days, using the function NetworkDays_Intl when the app is compiling shows me this: Run-time error 1004 Unable to get the NetworkDays_Intl property of the WorksheetFunction class

The code is:

Date = Application.WorksheetFunction.NetworkDays_Intl(Sheets("Report").Range("J4"),5,1,Sheets("Parameters").Range("B5:B26"))

I've checked the add-ins and all are active

excel vba

Solution 1:^[1]

Just convert the date in the range using CDate in this way you avoid the error when passing values as string or something else.

CDate(Sheets("Report").Range("J4").Value)

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source
Solution 1	Ike

'Issue detected in WorkDays_Intl vba error

Solution 1:[1]

Sources

Related Questions

Solution 1:^[1]