A reducing number by given dates

[jdmagoo]

Hi all, basically what im trying to create is a spreadsheet showing ho
many payments i have left on an item i purchased. Now i pay $100 o
this item on every 2nd friday. So my question is, what is a formul
that will look at todays date and reconise that it is the second frida
when payment is due and reduce a given figure in a cell by $100. Fo
example, Total cost is $1000, payments = $100, payments are due o
07/10/05, 21/10/05, 04/11/05 etc So when the 07/10/05 arrives tota
cost will = $900, when 21/10/05 arrives total cost will = 800 etc
Obviously when the date is other than specified the total cost dosn
change.

Hopefully i have made my self clear and somebody can help out with th
dilema

Many thanks
Jame

 

[Roger Govier]

See reply posted to same question in .newusers

Regards

Roger Govier

 

[Myrna Larson]

Hi, Roger:

I'm glad I looked at your reply in .newusers ! I didn't read the OP's message
carefully enough, and thought he meant by "second Friday" that there was one
payment a month, on the 2nd Friday of the month -- which is a different and
much more complicated issue!