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]

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

0

0

0

0

0

0

0

0

0

9

3

01/11/2018

30/04/2019

0

0

0

0

0

0

0

0

0

6

0

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 0 0 0 0 0 0 0 0 0 9 3 01/11/2018 30/04/2019 0 0 0 0 0 0 0 0 0 6 0 <colgroup><col span="12"><col><col span="3"></colgroup><tbody> </tbody>

<colgroup><col span="12"><col><col span="3"></colgroup><tbody>
</tbody>