choubix
06-20-2008, 02:19 AM
hello!
I am using an external adding that allows me to check if a given date is a business day according to a calendar. the syntax is: =isbusinessday(date, "calendar")
where date is the date and calendar can be HK, FR, UK...
the function returns 1 if it is a business day, 0 otherwise
right now I have this syntax in a For / Next loop:
If isbusinessdays(wsHistData.Cells(2, 6) + i, FinCenter1) And _
isbusinessdays(wsHistData.Cells(2, 6) + i, FinCenter2) And _
isbusinessdays(wsHistData.Cells(2, 6) + i, FinCenter3) <> 0 Then
each FinCenter is defined as follows:
FinCenter1 = wsHistData.Cells(1, 3)
FinCenter2 = wsHistData.Cells(2, 3)
FinCenter3 = wsHistData.Cells(3, 3)
the problem is that it returns an error (like the function is undefined)
I believe my syntax is wrong. can anyone help please?
thx
I am using an external adding that allows me to check if a given date is a business day according to a calendar. the syntax is: =isbusinessday(date, "calendar")
where date is the date and calendar can be HK, FR, UK...
the function returns 1 if it is a business day, 0 otherwise
right now I have this syntax in a For / Next loop:
If isbusinessdays(wsHistData.Cells(2, 6) + i, FinCenter1) And _
isbusinessdays(wsHistData.Cells(2, 6) + i, FinCenter2) And _
isbusinessdays(wsHistData.Cells(2, 6) + i, FinCenter3) <> 0 Then
each FinCenter is defined as follows:
FinCenter1 = wsHistData.Cells(1, 3)
FinCenter2 = wsHistData.Cells(2, 3)
FinCenter3 = wsHistData.Cells(3, 3)
the problem is that it returns an error (like the function is undefined)
I believe my syntax is wrong. can anyone help please?
thx