calculating rest value by depreciation

Hi there,

Allow me to introduce myself: My name is Marnix and I’m from the Netherlands. I joint this forum cause I’m kind of a noob with Excel en keep running in to trouble. I found a lot of answers al ready on this forum, thanks for that, but there is one I can’t solve/find.

To monitor my expenses I’m trying make a cash book in Excel. But I’m stuck with depreciation. Especially with the rest value. So far I’ve managed to get the depreciation period and the amount. But with calculating the current rest value the formula is not working.

I know the purchase date and the current date, but a can’t deduct them and get an answer in months! I need those months to multiply with the depreciation amount to know my rest value.

Can anyone help please?

Thanks in advance!

Marnix