Simplest way to filter dates

[Complus865]

Hi, what is the simpliest way to filter dates ?
I would like to know the sum of files in Quarter 1 (Jan, Feb, March) and Quarter 2 (April, May, June).

[KOKOSEK]

Excel 2016 (Windows) 32 bit

	E	F
5		Quantity
6	Q1	113761
7	Q2	62966

	E	F
5		Quantity
6	Q1	=SUMIFS($B:$B,$C:$C,">="&DATEVALUE("01/01/2020"),$C:$C,"<"&DATEVALUE("01/04/2020"))
7	Q2	=SUMIFS($B:$B,$C:$C,">="&DATEVALUE("01/04/2020"),$C:$C,"<"&DATEVALUE("01/07/2020"))

Sheet: Sheet1

[oeldere]

D2 =MONTH(C2)

E2 =VLookup(D2,Blad1!$A$1:$B$12,2,0)


After that a pivot table.

See the attached file.

[KOKOSEK]

You can pivot these data without any additional column and use option group in pivot table to group it by quaters.

Excel 2016 (Windows) 32 bit

	H	I
1	Row Labels	Sum of Total Invoiced
2	Qtr1	113761
3	**Jan	45045
4	**Feb	58094
5	**Mar	10622
6	Qtr2	62966
7	**May	57663
8	**Jun	5303
9	Qtr3	10460
10	**Jul	10460
11	Qtr4	26424
12	**Oct	10542
13	**Nov	10544
14	**Dec	5338
15	Grand Total	213611

Sheet: Sheet1

Check attached file.

[Complus865]

You can pivot these data without any additional column and use option group in pivot table to group it by quaters.

Excel 2016 (Windows) 32 bit

	H	I
1	Row Labels	Sum of Total Invoiced
2	Qtr1	113761
3	**Jan	45045
4	**Feb	58094
5	**Mar	10622
6	Qtr2	62966
7	**May	57663
8	**Jun	5303
9	Qtr3	10460
10	**Jul	10460
11	Qtr4	26424
12	**Oct	10542
13	**Nov	10544
14	**Dec	5338
15	Grand Total	213611

Sheet: Sheet1

Check attached file.

Hi this looks great, but how do you create the Qtr1 , Qtr2 in the pivot table ?

[KOKOSEK]

Right mouse button on Row labels, then choose Group and 1 of option is Quaterly.

[Complus865]

Thanks for the help, I need a little more time to explore myself.
I received some errors. But i will seek your help again if i can't solve it.

[oeldere]

Please also mark the question solved, if you found your solution.

The question was marked solved, sorry for my reply.