Average

I have a question. Is there a way to come up wht the average days worked from a weekending date with number of employees? For example, I have a weekending date of 1/2/2010 and 8 employees were employed on this date. Is there a way to average this out in excel?

This is what I am looking at. Does this help? How do I do averaging in excel? I am trying to get the average days that the 8 employees worked for w/e Jan 2, 2010. Thanks!


Week Ending # of Temps Avg Days

2-Jan 8
9-Jan 8
16-Jan 8
23-Jan 8
30-Jan 8
6-Feb 9
13-Feb 9
20-Feb 9
27-Feb 10
6-Mar 14
13-Mar 13
20-Mar 13
27-Mar 13
3-Apr 13
10-Apr 13
17-Apr 15
24-Apr 15
1-May 15
8-May 15
15-May 16
22-May 14
29-May 15
5-Jun 15
12-Jun 15
19-Jun 12

I am not sure that I understand well. Please, correct me if I am wrong...

I think that you only have to divide the number of employees at the end of the week with the number of working days per week.

Regards.

Yes, good point !!!

I am sorry, I took the average of employees per day, not the average of days per employee...