Number of employees at any one time

[djaldente]

I have got a list of employees start dates in one column and their finish dates in another column.

I need to calculate how many employees were present each month.

Any help would be greatly appreciated.

 

[Yongle]

This calculates how many employees were employed for at least ONE day in any month in 2019

Book1
	A	B	C	D	E	F	G	H
1	Name	Start	Finish			Month	Year	Count
2	John	08/02/2019	05/12/2019			January	2019	10
3	Jamie	10/12/2018	05/11/2019			February	2019	13
4	Jenny	11/10/2018	06/10/2019			March	2019	13
5	Jim	08/02/2019	05/12/2019			April	2019	13
6	Jimmy	10/12/2018	05/11/2019			May	2019	13
7	Janet	11/10/2018	06/10/2019			June	2019	13
8	Jane	12/08/2018	06/09/2019			July	2019	13
9	Joe	13/06/2018	07/08/2019			August	2019	13
10	Joseph	08/02/2019	05/12/2019			September	2019	11
11	Jeremy	10/12/2018	05/11/2019			October	2019	9
12	Jackie	11/10/2018	06/10/2019			November	2019	6
13	Jack	12/08/2018	06/09/2019			December	2019	3
14	Jason	13/06/2018	07/08/2019
15
16
Sheet3

Cell Formulas
Range	Formula
H2:H13	H2	=COUNTIFS(B:B,"<=" & EOMONTH(DATEVALUE(F2 & " " & G2),0),C:C,"")+COUNTIFS(B:B,"<=" & EOMONTH(DATEVALUE(F2 & " " & G2),0),C:C,">=" & DATEVALUE(F2 & " " & G2))

 

[djaldente]

Thanks mate!