is there a formula to count days someone worked?

[IJCVegas]

I have two columns on my spreadsheet. One that has the employee number for
the jobs that were completed, and the other the day the job was completed. Is
there a way to automate the average of the completed work with the days
worked and the jobs completed? I want to calculate the average number of jobs
that are being completed by each employee over a month.

 

[Mike H]

Hi,

Maybe this,

=SUMPRODUCT((A1:A30=123)*(MONTH(B1:B30)=2))


Where 123 is the employee No and 2 (february) is the month you are looking for

Mike

 

[Bob Phillips]

If you only have the complete date, how would you calculate the days worked,
when does a job start?

 

[Spiky]

If you only have the complete date, how would you calculate the days worked,
when does a job start?

I would also consider using hours. If there are several jobs/month for
each employee, that suggests that "days worked" is not detailed enough.