Employee Count

[gemblu]

Hello,

I need help with employee count for 2015. I've attached an example.
I need a formula that shows how many employees were employed per month in the year of 2015.

Thanks.

emp cnt.JPG

[Raymundus]

Assuming your data is in columns A:C starting at Row 1 with headers, Add a column to the right called "2015 count" or whatever you like...Add the formula below directly beneath it and copy down. Then just use the autofilter.

Please Login or Register  to view this content.

If your data is in different locations, you may adjust the column references in the formula

Thanks!

P.S. There are some extra sets of parentheses in the formula around the "less than" signs... There are some funny combinations of characters that upset the firewall gods

[gemblu]

I will try it out and let you know.

Thanks Raymundus!

[ChemistB]

So the person who resigned on 4/15/2015, would they be counted for April? How about if they resigned on 4/2/15?

[gemblu]

Yes, that is correct
And in the column with no date, they're still active

[6StringJazzer]

how many employees were employed per month

This is not a clear requirement. You have to determine the number of employees on a specific day. Do you want the last day of the month or the first day of the month?

This attachment will give the number on the last day of the month.

Also, in the future please attach an Excel file instead of an image if you want to provide sample data. Images are OK for charts or diagrams, but it's so much easier to help you if we have an Excel file with the data already set up.

[gemblu]

That worked....thanks everyone!!

[Raymundus]

Hey Six String... my formula just catches anyone who was an active employee anytime between 1 Jan. 2015 and 31 Dec. 2016 so gemblu could count the total number of active employees active at anytime in the year... I completely missed the per month piece in gemblu's original post...

Good Catch, and Thanks!

[6StringJazzer]

gemblu, if your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

If a member helped you solve your problem, consider adding to their reputation by clicking on the star icon below their name.