Rolling MM/DD/YYYY dates into Q/YYYY dates

[littlejilly]

Hi all, I have a few columns of dates that are formatted in MM/DD/YYYY. There are hundreds of dates in these columns and I am looking for a way to roll these up into each of the dates respective quarters. Essentially looking for a formula that will either countif or sumif the number of dates that are in each quarter.

Open to any thoughts and suggestions you may have.

Thanks!
littlejilly

 

[Aryatect]

Hi, 1 Option can be pivot table and grouping by Quarter and Year.

 

[Aryatect]

Another with helper column:

Book1
	L	M	N	O
1			Q3, 2019	63
2
3
4
5	Date	Quarter
6	7/30/2019	Q3, 2019
7	7/31/2019	Q3, 2019
8	8/1/2019	Q3, 2019
9	8/2/2019	Q3, 2019
Sheet3

Cell Formulas
Range	Formula
O1	=COUNTIF($M$6:$M$107,N1)
M6	="Q"&ROUNDUP(MONTH(L6)/3,0)&", "&YEAR(L6)

Without helper column:

Book1
	Q	R	S
1	Quarter	Year
2	3	2019	63
3
4
5	Date
6	7/30/2019
7	7/31/2019
8	8/1/2019
9	8/2/2019
Sheet3

Cell Formulas
Range	Formula
S2	=SUMPRODUCT((ROUNDUP(MONTH($Q$6:$Q$107)/3,0)=Q2)*(YEAR($Q$6:$Q$107)=R2))