A reducing number by given dates
 

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

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

Many thanks
James


--
jdmagoo
------------------------------------------------------------------------
jdmagoo's Profile: http://www.excelforum.com/member.php...o&userid=27814
View this thread: http://www.excelforum.com/showthread...hreadid=473243

See reply posted to same question in .newusers

Regards

Roger Govier



jdmagoo wrote:

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

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

Many thanks
James

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!


On Wed, 05 Oct 2005 11:56:16 +0100, Roger Govier
wrote:

See reply posted to same question in .newusers

Regards

Roger Govier



jdmagoo wrote:

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

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

Many thanks
James