Automatic Update of Cells Based on Date

A

andersonps77

Hi,

I have a pretty tough question here.

I have a spreadsheet that lists the total amount of money owed. I
lists the monthly payments and the due date of payments. What I'
trying to do is have it update the total amount owed when the due dat
arrives automatically. E.g.

Before Updating

Total Amount Monthy Payment Due Date
$1000 $50
10/08/04

After Updating

$950 $50
11/08/04

The Due Date field doesn't need to update automatically since I have
calendar function to put in a date in case it changes within the month
I'm not much of a programmer, so any assistance would be greatl
appreciated
 
Top