can any one help me Calculate working weekdays?
I am trying to calculate the number of working weekdays from two dates, at the moment it is giving me the full 7 days per week.
1 comment

John McGarvey commented
Hi Sam,
There is a date function just for this.
Hope this is what you are looking for.
John
weekdays()
This function returns the number of weekdays spanned by date1 and date2, including both date1 and date2.weekdays({Date Field 1}, {Date Field 2})
Note: If using this function alone, you would insert the function into a calculated text or calculated number field type. Because it returns a whole number, it will not be accepted into a date field type.