Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

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

Posted on 2016-09-29
6
Medium Priority
?
63 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
6 Comments
 
LVL 40

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 22

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 24

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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

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

Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

575 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