I have prepared one sheet related to monthly rental. Formula which I entered is working as well.
Is there any shortest way to fill the months column ("C" to "N") with Payment Column ("O") according to Start ("A") and End Dates ("B"). The dates could be in combinations of last year and current year, current year and next year, or current year.
I have attached the sample sheet herewith for your kind reference.