Completed

Excel formula help..IF THEN OR?

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.

Skills: Excel

See more: excel if statement multiple conditions range, if function with 3 conditions, if else excel, excel if function multiple conditions, multiple if statements in excel, if function excel, excel if function text, advanced if function in excel, need help with excel formula, excel formula help: need one-to-many vlookup type of formula, excel formula help, excel formula help need onetomany vlookup type of formula, do some excel formula or macro, accounting excel formula, excel formula capture data time day, excel formula network address range, excel formula projects, excel formula convert utm latitude, check excel formula aspnet, microsoft excel formula sheet

About the Employer:
( 1 review ) Largo, United States

Project ID: #17019682

Awarded to:

JorgeBece

Your problem has an easy solution so I offer yo fix It for the minimum prize so you fix your problem and I promote myself ( both of us win)

$10 USD in 1 day
(10 Reviews)
2.7

33 freelancers are bidding on average $24 for this job

schoudhary1553

Hello, I can help with you in your project Excel formula help..IF THEN OR? . I have more than 5 years of experience in Excel. We have worked on several similar projects before! We have worked on 300+ Projects. Plea More

$30 USD in 1 day
(229 Reviews)
7.4
P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$25 USD in 1 day
(264 Reviews)
7.0
ShaunKleinOnline

Hi there, Your project sounds interesting and I feel you've laid out the issues and specifications perfectly. Everything makes sense and I feel given my work experience I would be able to formulate some logic that w More

$30 USD in 1 day
(70 Reviews)
6.4
Saidul28

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

$20 USD in 1 day
(31 Reviews)
5.3
dvcontact

Hi, You won’t select the right candidate without knowing what your project on writing Excel formula to show when tenant's rents should start reading will look like. Fortunately, I can complete a part of your job befor More

$30 USD in 1 day
(29 Reviews)
5.3
AlexandrUKR

please clarify possible next steps

$30 USD in 1 day
(15 Reviews)
4.9
periyannas

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.

$25 USD in 1 day
(32 Reviews)
4.9
mail2vimalarora

Hi, i have gone through your project details and would like to take an opportunity to work on it. Being experienced in working on excel projects/macros/functions/formula extensively, I can help you in getting it do More

$15 USD in 0 days
(45 Reviews)
5.2
rajafaizan

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

$30 USD in 2 days
(28 Reviews)
4.5
AkilaArun

Hi, I am interested in discussing this task. I am not able to find the attachment in the job post. Would be helpful if you can share the file again. I have worked with a number of Excel tasks in the past and can g More

$20 USD in 1 day
(24 Reviews)
4.4
khurram1984

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

$20 USD in 1 day
(11 Reviews)
3.8
lherreraz

Hi there! I read the project's description and I'm sure that I can help you with this. I have a large experience working with advanced Excel, using formulas, functions and Macros using VB, the most important thing is t More

$20 USD in 10 days
(11 Reviews)
3.2
LeahAnson

I am an organized, experienced professional with more than fifteen years of experience. I have held titles such as Publishing Assistant, Administrative Assistant, Office Administrator, Insurance Administrator, and Gra More

$25 USD in 2 days
(3 Reviews)
3.2
afenache

Hi, I am a chemical engineer and I have over five years experience in using Excel at an advanced level (complex formulas, array formulas, pivot table and charts, macros and VBA scripts, automatic calculation sheets, More

$25 USD in 1 day
(8 Reviews)
3.4
hsingla85

Available Immediately | MS Excel Expert | Assured quality of the work | Received excellent feedback from the clients

$25 USD in 1 day
(6 Reviews)
3.1
$25 USD in 1 day
(1 Review)
2.2
user2690

Hi, good day, I'd like to help you with your spreadsheet, could you please share it? I can't see it as attatchment.

$14 USD in 2 days
(3 Reviews)
2.0
$15 USD in 2 days
(3 Reviews)
2.0
vijayvizzu7

I have 10+ years of experience in Excel,VBA, MS Access and other office automation. I am sure, i can handle your request and deliver as per your expectation within the time frame

$20 USD in 1 day
(2 Reviews)
1.6
$12 USD in 1 day
(5 Reviews)
1.3