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

This either sounds like a beginners question or a general question. I would
not use a macro for this.

"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