Countifs with text (month) criteria from date

[lovejanu4u]

formula Countifs with text (month) criteria from dates. I want to show in graphs from dates how many count happen for each months in a year.

 

[Toadstool]

Hi LoveJanu4u,

As long as you only want to graph one year then this should work. Select C1 to N2 and insert graph.

LoveJanu4u.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Date		Jan-20	Feb-20	Mar-20	Apr-20	May-20	Jun-20	Jul-20	Aug-20	Sep-20	Oct-20	Nov-20	Dec-20
2	1/1/2020		2	1	2	1	1	3	0	2	1	1	1	0
3	1/23/2020
4	2/14/2020
5	3/7/2020
6	3/29/2020
7	4/20/2020
8	5/12/2020
9	6/3/2020
10	6/25/2020
11	6/27/2020
12	8/8/2020
13	8/30/2020
14	9/21/2020
15	10/13/2020
16	11/4/2020
Sheet1

Cell Formulas
Range	Formula
D1:N1	D1	=EOMONTH(C1,0)+1
C2:N2	C2	=COUNTIFS($A$2:$A$9999,">="&C$1,$A$2:$A$9999,"<="&EOMONTH(C$1,0))

 

[lovejanu4u]

Thank you so much I am sure this will sort out my query. I will give feedback once applied.

 

[lovejanu4u]

Hi LoveJanu4u,

As long as you only want to graph one year then this should work. Select C1 to N2 and insert graph.

LoveJanu4u.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Date		Jan-20	Feb-20	Mar-20	Apr-20	May-20	Jun-20	Jul-20	Aug-20	Sep-20	Oct-20	Nov-20	Dec-20
2	1/1/2020		2	1	2	1	1	3	0	2	1	1	1	0
3	1/23/2020
4	2/14/2020
5	3/7/2020
6	3/29/2020
7	4/20/2020
8	5/12/2020
9	6/3/2020
10	6/25/2020
11	6/27/2020
12	8/8/2020
13	8/30/2020
14	9/21/2020
15	10/13/2020
16	11/4/2020
Sheet1

Cell Formulas
Range	Formula
D1:N1	D1	=EOMONTH(C1,0)+1
C2:N2	C2	=COUNTIFS($A$2:$A$9999,">="&C$1,$A$2:$A$9999,"<="&EOMONTH(C$1,0))

Dear Sir,
Greetings!

Thanks alot its working for making a graph.

Appreciated your idea and support.

Regards,