**Question description:**

*This user has given permission to use the problem statement for this blog.*

Looking for a formula to see the average amount of times something is made throughout the course of the week (Monday-Friday) from date form and name of product

Solved by S. A. in 37 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
28/08/2018 - 06:55

Welcome to ExcelChat!

User
28/08/2018 - 06:55

hi

Excelchat Expert
28/08/2018 - 06:55

Will you provide the data based on which you need the solution?

User
28/08/2018 - 06:57

i cant see anything on the goggle doc side because it is blocked. Refer to column M/N comparing date column A to column b

[Uploaded an Excel file]

Excelchat Expert
28/08/2018 - 06:58

Which sheet is that?

User
28/08/2018 - 06:59

sorry the succ 100

Excelchat Expert
28/08/2018 - 07:00

Could you describe what you need to see in column M and N?

Excelchat Expert
28/08/2018 - 07:00

You want the final result to be in column N, right?

User
28/08/2018 - 07:00

i need to see the weekly average according to the day of week in column n

User
28/08/2018 - 07:00

yes

Excelchat Expert
28/08/2018 - 07:01

What is weekly average? Is it the average from 7 days?

User
28/08/2018 - 07:01

monday-friday

User
28/08/2018 - 07:01

the average per day of week

User
28/08/2018 - 07:02

so i need to see the average occurance on monday, tuesday, wednesday etc

Excelchat Expert
28/08/2018 - 07:02

In which column can we see the fact of occurrence? Just from column A?

User
28/08/2018 - 07:03

column K has the specific day of week

Excelchat Expert
28/08/2018 - 07:03

Okay.. the final question

Excelchat Expert
28/08/2018 - 07:03

For example we take Monday

Excelchat Expert
28/08/2018 - 07:03

Do you want to see the total amount of preps for Monday?

User
28/08/2018 - 07:04

the average total amount of preps for all mondays in this sheet

Excelchat Expert
28/08/2018 - 07:04

What do you mean the average? You mean that we need to take all preps for Mondays and then divide by all Mondays?

User
28/08/2018 - 07:05

average as in..... on average how many preps are being produced on a monday based on this data

Excelchat Expert
28/08/2018 - 07:10

Okay, I will make a solution to calculate that

Excelchat Expert
28/08/2018 - 07:10

Please extend the session once you see the pop up message

User
28/08/2018 - 07:20

any luck?

Excelchat Expert
28/08/2018 - 07:21

Working on it.. will write you back once I finish

Excelchat Expert
28/08/2018 - 07:29

Please have your file ready

[Uploaded an Excel file]

Excelchat Expert
28/08/2018 - 07:30

I add a helper column which shows only unique days of weeks for each date, which allowed us to get the total number of each day

Excelchat Expert
28/08/2018 - 07:30

Then we just divide the total entries per Monday, for example, and divide on the total number of Mondays. In this way we get the average results for each day

Excelchat Expert
28/08/2018 - 07:31

Once you open the file, please force update all the calculations

Excelchat Expert
28/08/2018 - 07:31

So that your days of week would be shown on English

User
28/08/2018 - 07:31

okay thanks

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*