Receiving Parsing error using NETWORKDAY formula

Hi,
I would like to get the average working days between when a request is opened and approved.
I am starting off with the following formula to calculate the net working days for each requests. Then I will add the Average formula to get the average of all requests.
Here is the formula which is giving me unparseable error.
=NETWORKDAY(DATEONLY([Business Created D/T]:[Business Case Created D/T]), [Business Case Approved Date]:[Business Case Approved Date])
Also, if you can help me with what the formula to get the Average of the Net working days for each requests, that would be great.
Thanks for your help.
Best Answer
-
You are going to have to have the number of work days on each row in a separate column then average that column.
Answers
-
You are going to have to have the number of work days on each row in a separate column then average that column.
-
Thanks, @Paul Newcome . I thought I was going to have to go that route.
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!