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.

[TABLE="width: 694"]
<colgroup><col><col span="2"><col></colgroup><tbody>[TR]
[TD]StudentName[/TD]
[TD]Enrolled[/TD]
[TD]Withdrew[/TD]
[TD]Status[/TD]
[/TR]
[TR]
[TD]JamesMcIntire[/TD]
[TD="align: right"]07/22/19[/TD]
[TD="align: right"]08/22/19[/TD]
[TD]Inactive[/TD]
[/TR]
[TR]
[TD]SierraChristian[/TD]
[TD="align: right"]07/29/19[/TD]
[TD="align: right"]08/23/19[/TD]
[TD]Inactive[/TD]
[/TR]
[TR]
[TD]RodgerCummings[/TD]
[TD="align: right"]07/29/19[/TD]
[TD="align: right"]08/23/19[/TD]
[TD]Inactive[/TD]
[/TR]
[TR]
[TD]AvaleeStevens[/TD]
[TD="align: right"]07/29/19[/TD]
[TD="align: right"]08/23/19[/TD]
[TD]Inactive[/TD]
[/TR]
[TR]
[TD]KhloePowell[/TD]
[TD="align: right"]07/30/19[/TD]
[TD="align: right"]08/27/19[/TD]
[TD]Inactive[/TD]
[/TR]
[TR]
[TD]JoshuaShade[/TD]
[TD="align: right"]07/31/19[/TD]
[TD="align: right"]08/27/19[/TD]
[TD]Inactive[/TD]
[/TR]
[TR]
[TD]JacquilineBelcher[/TD]
[TD="align: right"]08/16/19[/TD]
[TD="align: right"]08/28/19[/TD]
[TD]Inactive[/TD]
[/TR]
[TR]
[TD]KennedyMynhier[/TD]
[TD="align: right"]08/19/19[/TD]
[TD="align: right"]08/28/19[/TD]
[TD]Inactive[/TD]
[/TR]
[TR]
[TD]SydneyWinter[/TD]
[TD="align: right"]08/21/19[/TD]
[TD="align: right"]08/28/19[/TD]
[TD]Inactive[/TD]
[/TR]
[TR]
[TD]DarriusWilkerson[/TD]
[TD="align: right"]08/21/19[/TD]
[TD="align: right"]08/29/19[/TD]
[TD]Inactive[/TD]
[/TR]
[TR]
[TD]RamonRamos Mendoza[/TD]
[TD="align: right"]08/21/19[/TD]
[TD="align: right"]08/30/19[/TD]
[TD]Inactive[/TD]
[/TR]
[TR]
[TD]EleanorSells[/TD]
[TD="align: right"]08/21/19[/TD]
[TD="align: right"]08/30/19[/TD]
[TD]Inactive[/TD]
[/TR]
[TR]
[TD]EricCalloway[/TD]
[TD="align: right"]08/21/19[/TD]
[TD="align: right"]09/02/19[/TD]
[TD]Inactive[/TD]
[/TR]
[TR]
[TD]HaleyJohnson[/TD]
[TD="align: right"]08/21/19[/TD]
[TD="align: right"]09/02/19[/TD]
[TD]Inactive[/TD]
[/TR]
[TR]
[TD]ErickLopez-Gonzalez[/TD]
[TD="align: right"]08/21/19[/TD]
[TD="align: right"]09/02/19[/TD]
[TD]Inactive
[/TD]
[/TR]
</tbody>[/TABLE]

The desired result is a summary looking like this:

[TABLE="width: 336"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD]Enrollments[/TD]
[TD]Withdrawals[/TD]
[/TR]
[TR]
[TD]Aug[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Sep[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Oct[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Nov[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]877[/TD]
[TD="align: right"]172[/TD]
[/TR]
</tbody>[/TABLE]


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