Excel - Autofill Monthly Rent according to Start Date, End Date and Payment with year change

Hi Experts,

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.

Regards,
D Patel
Monthly-Rent.xlsx
LVL 7
D PatelD Patel, Software EngineerAsked:
Who is Participating?
 
Ejgil HedegaardConnect With a Mentor Commented:
Remove Numbervalue from the formula, and the formula will be much shorter.
Year and Month fomulas returns numbers, so it is not needed.
1
 
PatHartmanCommented:
Excel is good for a lot of things but databases are better for managing data.  I see that you have Access included as a topic.  Does that mean that you are interested in Access as a solution?
1
 
D PatelD Patel, Software EngineerAuthor Commented:
Sorry,

The query is related to Excel.

I changed the Topic.
0
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

 
Roy CoxGroup Finance ManagerCommented:
Can you indicate what the result is that you are expecting
0
 
D PatelConnect With a Mentor D Patel, Software EngineerAuthor Commented:
The same result as depicted in the sheet.

But with different alternative formula. Because my formula is very lengthy.
0
 
D PatelD Patel, Software EngineerAuthor Commented:
Thanks for the help...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.