Number of months in each year between 2 dates in excel

[Mannai_Accounts]

I have 2 dates 01-Oct-2022 and 30-Sep-2026. How can Can I calculate number of months in each year (2022,2023,2024,2025,2026) with excel formula.

Start Date	End Date	2022	2023	2024	2025	2026
01-Oct-22	31-Jul-26	number of months ?	number of months ?	number of months ?	number of months ?	number of months ?

[#2]

can any one help pls!

[#3]

@Mannai_Accounts 

See the attached workbook.

[#4]

Thank you very much Hans Vogelaar.. appreciated!