Counting AVG Days

ayb

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

Mike TV

@ayb

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])