Count number of months per year between two dates

[BenB0425]

So I'm having trouble coming up with a formula to be able to count the number of months between two given dates and break it down by year. So if the dates are from (11/2018 until 8/2019) I would like it to break it down to 2 months for 2018 and 8 months for 2019. But I have a range of dates from 2011 until 2019. Below is a copy of the difference in months but I would like it to expand and elaborate on how many months per year were utilized. These date are just from 2017 until 2019 but I have other dates backing all the way to 2011.

03/2019	06/2018		10
03/2019	05/2018		11
03/2019	03/2018		13
03/2019	07/2017		21

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

Can anyone help?
Thanks

 

[BenB0425]

I feel like this never ending. I'm sorry. Some of the dates work but most do not. The last row is 2019 and it is calculating 10 months when it should be only 3 months in this example for 2019 and the rest for previous years. SMH. This is so frustrating.

Thanks

3/1/2019	08/2018	08/01/2018	7	0	0	0	0	0	0	0	0	10
3/1/2019	07/2018	07/01/2018	8	0	0	0	0	0	0	0	0	10
3/1/2019	05/2018	05/01/2018	10	0	0	0	0	0	0	0	0	10
3/1/2019	04/2018	04/01/2018	11	0	0	0	0	0	0	0	0	10
3/1/2019	11/2017	11/01/2017	16	0	0	0	0	0	0	0	0	10
3/1/2019	11/2018	11/01/2018	4	0	0	0	0	0	0	0	0	10
3/1/2019	11/2018	11/01/2018	4	0	0	0	0	0	0	0	0	10
3/1/2019	11/2018	11/01/2018	4	0	0	0	0	0	0	0	0	10
3/1/2019	11/2018	11/01/2018	4	0	0	0	0	0	0	0	0	10

<colgroup><col><col span="2"><col><col span="9"></colgroup><tbody>
</tbody>

 

[DanteAmor]

The structure of my example is not equal to the structure of your example, therefore you must adapt the formula.
Why not try my data and then adapt the formula to your data.