Monthly split from date range

[jaydj1]

Hi, I'm trying to find the best formula for my spreadsheet that shows me the number of months within a fiscal year, with a start and end date range . Could someone help?

 

[jaydj1]

[TABLE="width: 1036"]
<colgroup><col span="12"><col><col span="3"></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]01/10/2009[/TD]
[TD]01/10/2010[/TD]
[TD]01/10/2011[/TD]
[TD]01/10/2012[/TD]
[TD]01/10/2013[/TD]
[TD]01/10/2014[/TD]
[TD]01/10/2015[/TD]
[TD]01/10/2016[/TD]
[TD]01/10/2017[/TD]
[TD]01/10/2018[/TD]
[TD]01/10/2019[/TD]
[TD]01/10/2020[/TD]
[TD]01/10/2021[/TD]
[/TR]
[TR]
[TD]Start[/TD]
[TD]End[/TD]
[TD]Prior[/TD]
[TD]FY 10[/TD]
[TD]FY 11[/TD]
[TD]FY 12[/TD]
[TD]FY 13[/TD]
[TD]FY 14[/TD]
[TD]FY 15[/TD]
[TD]FY 16[/TD]
[TD]FY 17[/TD]
[TD]FY 18[/TD]
[TD]FY 19[/TD]
[TD]FY 20[/TD]
[TD]FY 21[/TD]
[TD]FY 22[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]01/01/2019[/TD]
[TD]31/12/2020[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]01/11/2018[/TD]
[TD]30/04/2019[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]

01/10/2009

01/10/2010

01/10/2011

01/10/2012

01/10/2013

01/10/2014

01/10/2015

01/10/2016

01/10/2017

01/10/2018

01/10/2019

01/10/2020

01/10/2021

Start

End

Prior

FY 10

FY 11

FY 12

FY 13

FY 14

FY 15

FY 16

FY 17

FY 18

FY 19

FY 20

FY 21

FY 22

01/01/2019

31/12/2020

01/11/2018

30/04/2019

<colgroup><col span="12"><col><col span="3"></colgroup><tbody>
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]3[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]0[/TD]

</tbody>

[/TD]
[/TR]
</tbody>[/TABLE]