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
[TABLE="width: 416"]
<colgroup><col><col><col span="2"></colgroup><tbody>[TR]
[TD]ESTES CONNER S[/TD]
[TD]T[/TD]
[TD="align: right"]6/6/2016[/TD]
[TD="align: right"] 11/30/2018[/TD]
[/TR]
[TR]
[TD]WILLIAMS JESSICA L[/TD]
[TD]T[/TD]
[TD="align: right"]9/18/2017[/TD]
[TD="align: right"]11/30/2018[/TD]
[/TR]
[TR]
[TD]CANTRELL HERBERT A[/TD]
[TD]T[/TD]
[TD="align: right"]10/9/2010[/TD]
[TD="align: right"]12/4/2018[/TD]
[/TR]
[TR]
[TD]TREFTS GARRY L[/TD]
[TD]T[/TD]
[TD="align: right"]6/9/2015[/TD]
[TD="align: right"]1/11/2019[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ABRASSART WESLEY [/TD]
[TD]A[/TD]
[TD="align: right"]5/26/2008[/TD]
[TD="align: right"]1/23/2019[/TD]
[/TR]
[TR]
[TD]ALLEN MICHAEL D[/TD]
[TD]A[/TD]
[TD="align: right"]1/30/2012[/TD]
[TD="align: right"]1/23/2019[/TD]
[/TR]
[TR]
[TD]BAILEY MATTHEW A[/TD]
[TD]A[/TD]
[TD="align: right"]10/5/2015[/TD]
[TD="align: right"]1/23/2019[/TD]
[/TR]
[TR]
[TD]BELL III GRADY R[/TD]
[TD]A[/TD]
[TD="align: right"]9/10/2012[/TD]
[TD="align: right"]1/23/2019[/TD]
[/TR]
[TR]
[TD]BISHIR MARK R[/TD]
[TD]A[/TD]
[TD="align: right"]5/26/2008[/TD]
[TD="align: right"]1/23/2019[/TD]
[/TR]
[TR]
[TD]BLANCHETTE ALAN DALE[/TD]
[TD]A[/TD]
[TD="align: right"]1/21/2015[/TD]
[TD="align: right"]1/23/2019[/TD]
[/TR]
[TR]
[TD]BOROS JOSEPH M[/TD]
[TD]A[/TD]
[TD="align: right"]12/18/2018[/TD]
[TD="align: right"]1/23/2019[/TD]
[/TR]
</tbody>[/TABLE]


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