# Add number of people based off of hire/termination dates

#### HeRoseInThree

##### Board Regular
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!!!!

### Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
Are you able to post some sample data to work with?

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.

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.

Excel 2013/2016
ABCDEFG
1
2ESTES CONNER ST06/06/201630/11/201801/01/201810
3WILLIAMS JESSICA LT18/09/201730/11/201801/02/201810
4CANTRELL HERBERT AT09/10/201004/12/201801/03/201810
5TREFTS GARRY LT09/06/201511/01/201901/04/201810
601/05/201810
701/06/201810
8ABRASSART WESLEYA26/05/200823/01/201901/07/201810
9ALLEN MICHAEL DA30/01/201223/01/201901/08/201810
10BAILEY MATTHEW AA05/10/201523/01/201901/09/201810
12BISHIR MARK RA26/05/200823/01/201901/11/20188
13BLANCHETTE ALAN DALEA21/01/201523/01/201901/12/20187
14BOROS JOSEPH MA18/12/201823/01/201901/01/2019
Today
Cell Formulas
RangeFormula
F3=EDATE(F2,1)
G2=COUNTIFS(C:C,"<="&F2,D:D,">"&F3-1)

Thanks!!!!!!!

Glad we could help & thanks for the feedback

Replies
2
Views
321
Replies
2
Views
166
Replies
0
Views
186
Replies
3
Views
362
Replies
2
Views
195

1,207,109
Messages
6,076,596
Members
446,215
Latest member
userds5593

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back