I am trying to calculate the number of working week-days from two dates, at the moment it is giving me the full 7 days per week.
Sam Doré shared this idea · May 24, 2017
can any one help me Calculate working week-days?
I am trying to calculate the number of working week-days from two dates, at the moment it is giving me the full 7 days per week.
Sam Doré shared this idea · May 24, 2017
Comments
1 comment
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.
Please sign in to leave a comment.