# Average working days based on 2 criteria

• Hello,

I got stuck and you guys are my last hope

I have a list of employees with start and end dates, locations, and ages.
Wanted to create a table that will show me the average working days (end date - start date) based on criteria of age and location.

And I can not crack it out I started with Averageif but besides that, I am out of ideas.

I attached a file for easier understanding.

Thank you in advance for all the suggestions.

• NETWORKDAYS will calculate the number of work days between the dates. I don't see how the criteria of age and location fit in to create an average.

• Hello royUk,

Let's split it into 2 parts:

1)
I need to find out the average number of days that have been worked in each location.
For example, different people worked in London, the start date and end date are different, so I want to know on average how many days people have worked in London.

2) also to split them by age.
As an example, we have 2 people of age 25 that have worked in London with different end and start dates so I want to count the average worked days for both of them.

I am not sure that I explained it clearly but thank you once again in advance for trying to help

• Yeah something like that just 1 stuff I can not add another row
is there a possibility to integrate =NETWORKDAYS(A8; B8) into the formula?

• in the file, you added a new column of Work Days.

in my source, I can not add such a column.
that is why I said that I can not manipulate and add this column and use it with the formula you specified in the file

• Hi sorry for late reply,

yeah maybe will have to think of another way to get it, but thank you for the help and guide