I am trying to calculate the number of working days in a month using the NETWORKDAYS function but it simply returning the number of days in the month. Am I using this incorrectly?
Solved
NETWORKDAYS Function Not Calculating Correctly
+3- Author
Best answer by Min Li
NETWORKDAYS(Month.'Start Date', Month.'End Date'+1, 'Day of Week'.'Working Days'=True)
You may need to +1 to the end of Month.'End Date', since the second date is not taken into account. If you want to include month end date, you may have to +1.
Under the ‘Day of Week’ dimension , you may need add an additional boolean property to specify which days are considered working days.
+12- Master Helper
- Answer
NETWORKDAYS(Month.'Start Date', Month.'End Date'+1, 'Day of Week'.'Working Days'=True)
You may need to +1 to the end of Month.'End Date', since the second date is not taken into account. If you want to include month end date, you may have to +1.
Under the ‘Day of Week’ dimension , you may need add an additional boolean property to specify which days are considered working days.
Min Li
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.