A reducing number by given dates

[jdmagoo]

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

[Roger Govier]

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
>
>
>
>

[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!


On Wed, 05 Oct 2005 11:56:16 +0100, Roger Govier
<[email protected]> 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
>>
>>
>>
>>