Forum Discussion
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 |
| 01-Oct-22 | 31-Jul-26 | number of months ? | number of months ? | number of months ? | number of months ? | number of months ? |
- can any one help pls!
See the attached workbook.
- Thank you very much Hans Vogelaar.. appreciated!
