Monthly Headcount

[Dandelion3]

Hi everyone,

I am building an excel dashboard and need help calculating total headcount each month. Included in my raw data, I have original hire date and termination date. I would like a monthly ending total including any terminations for that month. I would also like to be able to show monthly and biweekly changes for the last 12 months. Please help.

 

[SanjayGMusafir]

Share some sample data using XL2BB. It's important to understand how you maintain your raw data.

Also share a sample result that you want to generate to understand your requirements.

 

[Dandelion3]

Share some sample data using XL2BB. It's important to understand how you maintain your raw data.

Also share a sample result that you want to generate to understand your requirements.

Image attached. This is sample data of active employees with original hire and termination date (if blank, they're still employed)