Forum Discussion
Mannai_Accounts
Nov 14, 2022Copper Contributor
Number of months in each year between 2 dates in excel
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...
HansVogelaar
Nov 14, 2022MVP
See the attached workbook.
mannaiexcelquery
Nov 14, 2022Copper Contributor
Thank you very much Hans Vogelaar.. appreciated!