|Subject:||Calculating rents and months past in 1 cell???|
|Posted by:||Ricardo Barroso|
|Date:||Wed, 28 Jun 2006|
IÂ´m making a Worksheet to calculate the Residual Value of car at the time
the worksheet is open.
So i have colums with the "inicial date of the contract", "Final date of the
contract", "the monthly rent", and the "car value when purchased".
With this colums i need to calculate the value of the car at today date.
This columm as to do this:
"Value of the car when Purchased" - (MINUS) "rents payed since the begining
of the contract until todays date".
How can i make excel calculate this.