Filtering by Date

Good evening,

I have a table with the following fields,

Type A Employee - this shows a 1 if they fit that category.

Start Date - the date the employee started with our company

I need to count the number of Type A employees and then filter this by the number of employees working for the company on various dates.

I have another table in the model that shows what status each employees time sheets are at.

The final view needs to show the week commencing, number of Type A employees, and the status from the other table.

I have been going round in circles and would appreciate any help. Thank you.