Add number of people based off of hire/termination dates

[HeRoseInThree]

I need to calculate the number of people employed at a certain time frame. How many hired before january 1, 2018 and still employed on January 31, 2018. The same for each month after...

Hire date is in column H and term date is in column I. If they are still employed add them all up. If not, skip them.

Any help would be appreciated!!!!

 

[RasGhul]

Are you able to post some sample data to work with?

 

[HeRoseInThree]

A B C D

ESTES CONNER S	T	6/6/2016	11/30/2018
WILLIAMS JESSICA L	T	9/18/2017	11/30/2018
CANTRELL HERBERT A	T	10/9/2010	12/4/2018
TREFTS GARRY L	T	6/9/2015	1/11/2019
ABRASSART WESLEY	A	5/26/2008	1/23/2019
ALLEN MICHAEL D	A	1/30/2012	1/23/2019
BAILEY MATTHEW A	A	10/5/2015	1/23/2019
BELL III GRADY R	A	9/10/2012	1/23/2019
BISHIR MARK R	A	5/26/2008	1/23/2019
BLANCHETTE ALAN DALE	A	1/21/2015	1/23/2019
BOROS JOSEPH M	A	12/18/2018	1/23/2019

<colgroup><col><col><col span="2"></colgroup><tbody>
</tbody>

A is the driver's name, B is active or termed, c is hire date and d is term date or todays date if they are still employed.

 

[horrellbt01]

Try this out
=COUNTIFS(C:C,"<=1/1/2018",D:D,">=1/31/2018")

Would need to change the dates for each month, but that should give you what you are looking for if I understand the goal correctly.

 

[Fluff]

How about

Excel 2013/2016
	A	B	C	D	E	F	G
1
2	ESTES CONNER S	T	06/06/2016	30/11/2018		01/01/2018	10
3	WILLIAMS JESSICA L	T	18/09/2017	30/11/2018		01/02/2018	10
4	CANTRELL HERBERT A	T	09/10/2010	04/12/2018		01/03/2018	10
5	TREFTS GARRY L	T	09/06/2015	11/01/2019		01/04/2018	10
6						01/05/2018	10
7						01/06/2018	10
8	ABRASSART WESLEY	A	26/05/2008	23/01/2019		01/07/2018	10
9	ALLEN MICHAEL D	A	30/01/2012	23/01/2019		01/08/2018	10
10	BAILEY MATTHEW A	A	05/10/2015	23/01/2019		01/09/2018	10
11	BELL III GRADY R	A	10/09/2012	23/01/2019		01/10/2018	10
12	BISHIR MARK R	A	26/05/2008	23/01/2019		01/11/2018	8
13	BLANCHETTE ALAN DALE	A	21/01/2015	23/01/2019		01/12/2018	7
14	BOROS JOSEPH M	A	18/12/2018	23/01/2019		01/01/2019
Today

Cell Formulas
Range	Formula
F3	=EDATE(F2,1)
G2	=COUNTIFS(C:C,"<="&F2,D:D,">"&F3-1)

 

[HeRoseInThree]

Thanks!!!!!!!

 

[Fluff]

Glad we could help & thanks for the feedback