How to make attendance table??

[Mehmood6514]

We have 300 employes in our company.
I want to make attendance sheet. Which record everyday employee activity like he is working on base or outdoor location..

I can make simple table for each employee name in one column, but i am not understanding how i assigne each day...

I also want to summarize that how many people on each location on specific month or year??

Currently we are having one sheet for each month with employee name in first column and next column for each day.

And for summery we use formula for data analysis which hang thee excell.