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.
April 7, 2010 1:16 AM
November 9, 2012 4:09 PM