How to use excel to calculate values regarding dates?

**Garashta** · 07-14-2009, 11:36 AM

I need to calculate thousands of values, and the way I need to this is the following:

1) Each value is a debt that was contracted at a specified day, and this may differ from debt to debt
2) The tax is 3% month for every debt
3) I need to know how much these debts were worth at a specified time in the past.

Example: One debt of 104563USD was contracted day 16 november 2008, and I need to know how much it was worth at day 9 july 2009. And the same with many others, but the date the debt took place changes from debt to debt.
I'm doing it manually with HP12c, but it is taking toooo long =/
Any help is appreciated!

**deemo** · 07-14-2009, 11:52 AM

Not sure what you want to do here - perhaps an example spreadsheet would clarify.
In it simplest form you'd have something like

A1 B1 C1
$100 10-Feb-09 15-Mar-09

then the debt would be A1+((C1-B1)*A1*36/365). You can change C1 at any time to get the debt at that time?

PS: Rather than applying 3% per month regardless whether the month has 28 or 31 days - it might be an idea to apply 36% per year