cancel
Showing results for 
Search instead for 
Did you mean: 

WORKDAYS_BETWEEN()

Former Member
0 Kudos

Helli,

We are on SP11 and I am trying to find the workdays(excludes Holidays) between  2 dates.

I tried using the function WORKDAYS_BETWEEN. Following is the error message.
Can you please help.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

I have just observed that WORKDAYS_BETWEEN() function is missing in Date Functions list shown below, which might be the reason for your issue.

Regards,
Shireesha

Astrid_Gambill
Contributor
0 Kudos

You have to switch the Language selection to SQL in order to see the Workdays_between function.

Astrid_Gambill
Contributor
0 Kudos

I think it might be a bug.  that function works in the SQL console, but not for a calculated column, even though its in the list.