Hello All,
Thanks in advance for your help. I currently have a column which contains dates that a set of quotes are valid until in the column next to it. So for example, a contract quote is 1500 dollars (a1) that is valid until 1/1/2012 (b1) with a quarterly payment of 300 (c1). Once 1/1/2012 passes, the quote will be 1200 and the valid date will be 4/1/2012.
How can I have these date and quote fields update automatically using the cell (c1) with the payment. I understand the PMT function, but it is silly to use in this instance. Obviously I can add 3 months to the valid dates currently setup, but i don't know how to do this and have it subtract the contract payments.
Thanks in advance for your help. I currently have a column which contains dates that a set of quotes are valid until in the column next to it. So for example, a contract quote is 1500 dollars (a1) that is valid until 1/1/2012 (b1) with a quarterly payment of 300 (c1). Once 1/1/2012 passes, the quote will be 1200 and the valid date will be 4/1/2012.
How can I have these date and quote fields update automatically using the cell (c1) with the payment. I understand the PMT function, but it is silly to use in this instance. Obviously I can add 3 months to the valid dates currently setup, but i don't know how to do this and have it subtract the contract payments.
