PMT AND YEARS - AUTOMATIC

[Pietro Di Micio]

Hi guys!

I've used the formula to calculate the monthly value of an installment; but, I have 06 columns (2023, 2024, 2025, 2026, 2027 and 2028) to automate the periods, for example: If I put the period of 60 months... I would like the monthly installment in 2023 will be multiplied by 7 (Jun-Dec) and in all other years by 12... in the last year, 2028, by 5 (Jan-May) completing 60 months; BUT if I change the period from 60 to 36, for example, I would like to automatically multiply the PMT by 7 in 2023, 12 in 2024 and 2025 and 5 in 2026, zeroing out the years 2027 and 2028.

Thanks in advance for the help.

Best!

 

[Pietro Di Micio]

I found the issue! 2023 = should be a complete date!

tks a lot

 

[Dave Patton]

Thanks for the feedback.
The formula should have worked when you tried it on your system.
The post also shows the number for the dates when we scroll over the cell in the post.
I should have mentioned that the years were dates custom formatted to show year.