Counting AVG Days
Might be a simple solution, but I've been playing around with it long enough and give up.
I'm trying to calculate the average amount of days to complete a process, for example;
Process Start Date End Date
Process 1 09/03/2022 09/20/2022
Process 2 09/06/2022 09/16/2022
Process 3 10/01/2022 10/10/2022
And so on.
What I am trying to accomplish is to capture the cumulative average number of start and end days for all processes, so I can say our process takes x amount of days on average.
I hope that makes sense.
Thanks
Answers
-
If you're not adding new Processes all the time, you can use a static formula such as this:
=AVG(NETDAYS([Start Date]@row, [End Date]@row), NETDAYS([Start Date]2, [End Date]2), NETDAYS([Start Date]3, [End Date]3))
However if you're adding Processes all the time which I'm guessing you are, you'll want to do it like this. Add a helper column with a column formula in it such as:
=NETDAYS([Start Date]@row, [End Date]@row)
Then you can make a Sheet Summary cell with a formula such as this:
=AVG([# of Days]:[# of Days])
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!