count current months occurrences

[redspanna]

Hello all

as per excel sheet example below, I would like a formula that will check down the dates in column A and count the current months occurrences.

Running (version 2).xlsb.xlsm
	A	B	C	D
1	11-Jan-21		Apr 21	2
2	15-Jan-21		Mar 21	4
3	17-Jan-21		Feb 21	2
4	18-Feb-21		Jan 21	3
5	19-Feb-21
6	02-Mar-21
7	04-Mar-21
8	06-Mar-21
9	11-Mar-21
10	01-Apr-21
11	04-Apr-21
12
Sheet1

Cell Formulas
Range	Formula
C1	C1	=TEXT(TODAY(),"Mmm yy")
C2	C2	=TEXT(TODAY()-30,"Mmm yy")
C3	C3	=TEXT(TODAY()-65,"Mmm yy")
C4	C4	=TEXT(TODAY()-90,"Mmm yy")

So the formula in cell C1 shows current month is Apr21 and I'd like a formula then placed into cell D1 to give the result shown in D1

Thanks in advance

 

[Fluff]

How about

+Fluff 1.xlsm
	A	B	C	D
1
2	11/01/2021		01/04/2021	2
3	15/01/2021		01/03/2021	4
4	17/01/2021		01/02/2021	2
5	18/02/2021		01/01/2021	3
6	19/02/2021
7	02/03/2021
8	04/03/2021
9	06/03/2021
10	11/03/2021
11	01/04/2021
12	04/04/2021
13
Main

Cell Formulas
Range	Formula
C2	C2	=EOMONTH(TODAY(),-1)+1
D2:D5	D2	=COUNTIFS(A:A,">="&C2,A:A,"<="&EOMONTH(C2,0))
C3	C3	=EOMONTH(TODAY(),-2)+1
C4	C4	=EOMONTH(TODAY(),-3)+1
C5	C5	=EOMONTH(TODAY(),-4)+1

 

[redspanna]

How about

+Fluff 1.xlsm
	A	B	C	D
1
2	11/01/2021		01/04/2021	2
3	15/01/2021		01/03/2021	4
4	17/01/2021		01/02/2021	2
5	18/02/2021		01/01/2021	3
6	19/02/2021
7	02/03/2021
8	04/03/2021
9	06/03/2021
10	11/03/2021
11	01/04/2021
12	04/04/2021
13
Main

Cell Formulas
Range	Formula
C2	C2	=EOMONTH(TODAY(),-1)+1
D2:D5	D2	=COUNTIFS(A:A,">="&C2,A:A,"<="&EOMONTH(C2,0))
C3	C3	=EOMONTH(TODAY(),-2)+1
C4	C4	=EOMONTH(TODAY(),-3)+1
C5	C5	=EOMONTH(TODAY(),-4)+1

Perfect - thanks so much

 

[Fluff]

You're welcome & thanks for the feedback.