Calculate amount of months between 2 "dates" with extra parameter

Hello all,

I've been given an excell file where I need to automatically calculate the amount of months between two dates.
The first catch is that the dates are not written in the standard date format but like this: 201603 (the year with the month following it, no days)
I've managed to come up with a way to calculate the amount of months between yet struggle when I want to add another parameter.
I need to calculate it per year too. (it only needs to count the amount of months of one year, like when the dates inputted are 201601 - 201705 it only needs to tell me the amount of months in 2016)

For example:
The info that is in the excel file: 201608____201703 (= 8 months)

What I need excel to do and show:
First column: 5 months (excel needs to calculate with these numbers: 201608_____201612)
Second Column: 3 months (excel needs to calculate with these numbers: 201701______201703 = )

Is this possible?

Thank you in advance and best regards,

M.

Your example is misleading, as in row 11 you don't have any months in 2018.

Will the span of years always be a maximum of 2, or might you have some dates from 2016 to 2018, or even longer?

Pete

Apologies, I made this during work. No time and too much work, it's stressing me out :/

Attached the version with updated headers.

The idea is that it will start in 2016 all the way until (and included) 2020.
However most periods will never go over 2 years. The maximum amount of years I can find back in my files is 2 years (for example 201503---201610)

Yeah I get this huge excel file from a coworker and well I just started at the company and they used this method for some time now...
I could change it though in my files, no one would bat an eye I guess, if the results are correct that is :p

Then I would use the formula '=1+(YEAR(LDate)-YEAR(EDate))*12+MONTH(LDate)-MONTH(EDate)

But how would I then be able to filter it to only calculate it for one year instead of the entire period?

Attached the excel with normal dates.