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.
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
Can anyone help?
Thanks
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