Month Count in a given year

[exalex]

Hello! How I am trying to figure out how to get a count per year - what formula would I use to get the answers that are in row E3 and F3?

[TABLE="width: 498"]
<tbody>[TR]
[TD="align: right"]1[/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD]beginning[/TD]
[TD]end[/TD]
[TD]Year[/TD]
[TD]Year[/TD]
[TD]Count[/TD]
[TD]Count[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD]11/1/2017[/TD]
[TD]10/31/2018[/TD]
[TD="align: right"]2017[/TD]
[TD="align: right"]2018[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD]11/1/2018[/TD]
[TD]10/31/2019[/TD]
[TD="align: right"]2018[/TD]
[TD="align: right"]2019[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD]11/1/2019[/TD]
[TD]10/31/2020[/TD]
[TD="align: right"]2019[/TD]
[TD="align: right"]2020[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD]11/1/2020[/TD]
[TD]10/31/2021[/TD]
[TD="align: right"]2020[/TD]
[TD="align: right"]2021[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD]11/1/2021[/TD]
[TD]10/31/2022[/TD]
[TD="align: right"]2021[/TD]
[TD="align: right"]2022[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]8[/TD]
[TD]11/1/2022[/TD]
[TD]10/31/2023[/TD]
[TD="align: right"]2022[/TD]
[TD="align: right"]2023[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody><colgroup><col><col span="2"><col span="4"></colgroup>[/TABLE]

 

[Scott Huish]

What does the 2 and 10 represent?

 

[exalex]

2 represents "2" months in 2017, 10 represents 10 months in 2018.

 

[Scott Huish]

Perhaps:

In E2: =13-MONTH(A2)
In F2: =MONTH(B2)

Excel 2010
	A	B	C	D	E	F
1	beginning	end	Year	Year	Count	Count
2	11/1/2017	10/31/2018	2017	2018	2	10
3	11/1/2018	10/31/2019	2018	2019	2	10
4	11/1/2019	10/31/2020	2019	2020	2	10
5	11/1/2020	10/31/2021	2020	2021	2	10
6	11/1/2021	10/31/2022	2021	2022	2	10
7	11/1/2022	10/31/2023	2022	2023	2	10
Sheet1

Cell Formulas
Range	Formula
E2	=13-MONTH(A2)
E3	=13-MONTH(A3)
E4	=13-MONTH(A4)
E5	=13-MONTH(A5)
E6	=13-MONTH(A6)
E7	=13-MONTH(A7)
F2	=MONTH(B2)
F3	=MONTH(B3)
F4	=MONTH(B4)
F5	=MONTH(B5)
F6	=MONTH(B6)
F7	=MONTH(B7)

 

[exalex]

Thank you so much!