I am new to Excel and have a project to do tomorrow at my new position. We have contracts that start on a certain date in 2010 and will bill for various time periods. For example, we received a 240,000contract and will bill for the remainder of 2010 at $10,000 per month. The total for 2010 will then be $90,000. I would like a formula that would then calculate the balance to be billed in 2011. Can you help me figure out a formula that will do this based on the start date of 4/1/2010.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!