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.

[TABLE="width: 505"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]03/2019[/TD]
[TD]06/2018[/TD]
[TD][/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]03/2019[/TD]
[TD]05/2018[/TD]
[TD][/TD]
[TD]11[/TD]
[/TR]
[TR]
[TD]03/2019[/TD]
[TD]03/2018[/TD]
[TD][/TD]
[TD]13[/TD]
[/TR]
[TR]
[TD]03/2019[/TD]
[TD]07/2017[/TD]
[TD][/TD]
[TD]21[/TD]
[/TR]
</tbody>[/TABLE]


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


[TABLE="width: 1098"]
<colgroup><col><col span="2"><col><col span="9"></colgroup><tbody>[TR]
[TD]3/1/2019[/TD]
[TD]08/2018[/TD]
[TD]08/01/2018[/TD]
[TD]7[/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"]10[/TD]
[/TR]
[TR]
[TD]3/1/2019[/TD]
[TD]07/2018[/TD]
[TD]07/01/2018[/TD]
[TD]8[/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"]10[/TD]
[/TR]
[TR]
[TD]3/1/2019[/TD]
[TD]05/2018[/TD]
[TD]05/01/2018[/TD]
[TD]10[/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"]10[/TD]
[/TR]
[TR]
[TD]3/1/2019[/TD]
[TD]04/2018[/TD]
[TD]04/01/2018[/TD]
[TD]11[/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"]10[/TD]
[/TR]
[TR]
[TD]3/1/2019[/TD]
[TD]11/2017[/TD]
[TD]11/01/2017[/TD]
[TD]16[/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"]10[/TD]
[/TR]
[TR]
[TD]3/1/2019[/TD]
[TD]11/2018[/TD]
[TD]11/01/2018[/TD]
[TD]4[/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"]10[/TD]
[/TR]
[TR]
[TD]3/1/2019[/TD]
[TD]11/2018[/TD]
[TD]11/01/2018[/TD]
[TD]4[/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"]10[/TD]
[/TR]
[TR]
[TD]3/1/2019[/TD]
[TD]11/2018[/TD]
[TD]11/01/2018[/TD]
[TD]4[/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"]10[/TD]
[/TR]
[TR]
[TD]3/1/2019[/TD]
[TD]11/2018[/TD]
[TD]11/01/2018[/TD]
[TD]4[/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"]10[/TD]
[/TR]
</tbody>[/TABLE]

 

[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.