?
Solved

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

Posted on 2016-09-29
6
Medium Priority
?
54 Views
Last Modified: 2016-10-05
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
0
Comment
Question by:D Patel
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 38

Expert Comment

by:PatHartman
ID: 41821993
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
 
LVL 7

Author Comment

by:D Patel
ID: 41822070
Sorry,

The query is related to Excel.

I changed the Topic.
0
 
LVL 21

Expert Comment

by:Roy Cox
ID: 41822098
Can you indicate what the result is that you are expecting
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 7

Assisted Solution

by:D Patel
D Patel earned 0 total points
ID: 41822184
The same result as depicted in the sheet.

But with different alternative formula. Because my formula is very lengthy.
0
 
LVL 23

Accepted Solution

by:
Ejgil Hedegaard earned 2000 total points
ID: 41822550
Remove Numbervalue from the formula, and the formula will be much shorter.
Year and Month fomulas returns numbers, so it is not needed.
1
 
LVL 7

Author Closing Comment

by:D Patel
ID: 41829458
Thanks for the help...
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

741 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question