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???
 

lets say that:
"inicial date of the contract" is in cell a2
"Final date of the contract" --"-- b2
"the monthly rent" c2
"car value when purchased" d2

then enter below function in any cell (make sure cell is formatted as
numbers not dates format)

=D2-(YEAR(A2)*12+MONTH(A2))-(YEAR(TODAY())*12+(MONTH(TODAY())))*C2

hope this is what you mean

"Ricardo Barroso" wrote:

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