Employee headcount by month

[Rokitt]

Hi- I want to count the number of employees in a given month based on the start and end dates. Attached is the excel. I have used the sumproduct formula but it does not give me the correct answer. Can anyone please help?

[Tony Valko]

In column C where there are no end dates, how should those be counted?

[José Augusto]

Try this

Please Login or Register  to view this content.

[Rokitt]

They should be counted if they should have started on or before the date that the formula is calculated.
In other words headcount for sep-2016, oct-2016, nov-2016 & dec-2016 should show 7.
Since John joined on 19-Sep-2016, the count for aug-2016 should not account him.

[Rokitt]

Thank you but this shows only new hires hired that month. I want to see how many active employees we have in a given month.

[Tony Valko]

Can you update the sample to show us what results you expect?

[José Augusto]

Try this

Please Login or Register  to view this content.

Note: Use in F39 a date far ahead

[Rokitt]

Awesome!! Thank you Jose, that is exactly what I needed

Thank you Jose and Tony for your time!!