Counting Monthly Enrollment and Withdrawals

[Andy0311]

Hello,

I have a table with StudentName, DateEnrolled, DateWithdrawn, and Status ( Active or Inactive ). My sample shows just a few rows, although the Enrollment shows nearly 900 rows and the Withdrawal column about 172. Both are subject to change daily, in which the chart would be updated.

StudentName	Enrolled	Withdrew	Status
JamesMcIntire	07/22/19	08/22/19	Inactive
SierraChristian	07/29/19	08/23/19	Inactive
RodgerCummings	07/29/19	08/23/19	Inactive
AvaleeStevens	07/29/19	08/23/19	Inactive
KhloePowell	07/30/19	08/27/19	Inactive
JoshuaShade	07/31/19	08/27/19	Inactive
JacquilineBelcher	08/16/19	08/28/19	Inactive
KennedyMynhier	08/19/19	08/28/19	Inactive
SydneyWinter	08/21/19	08/28/19	Inactive
DarriusWilkerson	08/21/19	08/29/19	Inactive
RamonRamos Mendoza	08/21/19	08/30/19	Inactive
EleanorSells	08/21/19	08/30/19	Inactive
EricCalloway	08/21/19	09/02/19	Inactive
HaleyJohnson	08/21/19	09/02/19	Inactive
ErickLopez-Gonzalez	08/21/19	09/02/19	Inactive

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

The desired result is a summary looking like this:

	Enrollments	Withdrawals
Aug
Sep
Oct
Nov
	877	172

<colgroup><col><col><col></colgroup><tbody>
</tbody>

I just can't figure out how to sum up the number of dates in each month to get a total. The totals showing I got by counting the entries in both columns. I tried a Pivot Table but couldn't get mine right, if that's even the way to get it. Any help would be greatly appreciated. Thank you.

Andy

 

[Fluff]

How about

Book1
	A	B	C	D	E	F	G	H	I
1	StudentName	Enrolled	Withdrew	Status				Enrolled	Withdrew
2	JamesMcIntire	22/07/2019	22/08/2019	Inactive			01/07/2019	6	0
3	SierraChristian	29/07/2019	23/08/2019	Inactive			01/08/2019	9	12
4	RodgerCummings	29/07/2019	23/08/2019	Inactive			01/09/2019	0	3
5	AvaleeStevens	29/07/2019	23/08/2019	Inactive
6	KhloePowell	30/07/2019	27/08/2019	Inactive
7	JoshuaShade	31/07/2019	27/08/2019	Inactive
8	JacquilineBelcher	16/08/2019	28/08/2019	Inactive
9	KennedyMynhier	19/08/2019	28/08/2019	Inactive
10	SydneyWinter	21/08/2019	28/08/2019	Inactive
11	DarriusWilkerson	21/08/2019	29/08/2019	Inactive
12	RamonRamos Mendoza	21/08/2019	30/08/2019	Inactive
13	EleanorSells	21/08/2019	30/08/2019	Inactive
14	EricCalloway	21/08/2019	02/09/2019	Inactive
15	HaleyJohnson	21/08/2019	02/09/2019	Inactive
16	ErickLopez-Gonzalez	21/08/2019	02/09/2019	Inactive
Database

Cell Formulas
Range	Formula
H2	=COUNTIFS(B:B,">="&$G2,B:B,"<"&EDATE($G2,1))
I2	=COUNTIFS(C:C,">="&$G2,C:C,"<"&EDATE($G2,1))

 

[Andy0311]

I tried it and it worked perfectly. Thank you for your assistance. It helps so much. Cheers, Fluff!

 

[Fluff]

You're welcome & thanks for the feedback