Calculating rents and months past in 1 cell???
 

Hi,

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.

Sincerely

Calculating rents and months past in 1 cell???
 

To find out the number of months, you would use this formula...

=(YEAR(NOW())-YEAR(A1))*12+MONTH(NOW())-MONTH(A1)

What you need to do is put ="Value of the car when purchased"-("the
monthly rent"*(YEAR(NOW())-YEAR(A1))*12+MONTH(NOW())-MONTH(A1)

Make sure you format the cell as general


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=556481