I have a rental facility with approx 100 units. I use a spreadsheet to manage the rentals and when I have a tenant move in anywhere past January...say like March, my current spreadsheet cant determine when the rent is supposed to start and always defaults to January. This causes my move in tenant to look as if they owe Jan&Feb when in reality their rent is supposed to start in March. This lack of a proper formula is also a problem if a rent increase happens later in the year like in June...it will apply my increase starting in January and affects the balances Jan-May. I am hoping to find a formula that will pick from a date list and only populate the correct month. I have attached a sample spreadsheet showing what the layout looks like.
34 freelancers are bidding on average $24 for this job
Hi.. I am expert in excel work. i have done many excel project before successfully. if you want then i can do your project also. if you want i can provide sample work before project start. thanks
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fourteen excel vba projects in the past seventy days. Willing to take up your project. Thank you, Regards.
Hello There, I read project description and i'm sure i can find using formula as per your instruction. I have lot of experience in excel, formula and function. chat with me for more detail. Thank you
Hi. i am using excel since 2009. I can take care of your requirements and prepare required excel sheet. kindly share your sheet for working. You can also contact me over s k y p e