Need help with headcount pivot table

[obionenairobi]

hello,

I have been trying to create a pivot table for the headcount in our company but I am completely stuck

See also attached Excel

I have a database from which I pull the data of all employees worldwide
I have name, starting date, end date, department and position

I would like to make a pivot which shows me for each month of the year how many employees I had in a certain department
In the attached Excel you can see the format I am after

Anybody that can help me out with this?

[bhenlee]

I think you need to add a helper column in your data which shows the month of hiring.

Something like =MONTH(B2)

[obionenairobi]

But how will this put a 1 in each month that a person is working between the hiring and termination date?