If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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=473240 |
#2
|
|||
|
|||
Hi
One way, with your purchase price in A1, enter in A2 =A1-INT((TODAY()-"23/09/2005")/14)*100 or if you just want to use a single cell, then =1000-INT((TODAY()-"23/09/2005")/14)*100 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Need Subforms? | AccessRookie | Using Forms | 7 | April 8th, 2005 09:30 AM |
Combo Box (1st) Populating Text Box (2nd) Field | AccessRookie | Using Forms | 1 | April 6th, 2005 11:37 PM |
Displaying elapsed number of weeks between two dates | SJ | Running & Setting Up Queries | 1 | February 28th, 2005 04:33 PM |
Number of working days between two dates | James Silverton | Worksheet Functions | 3 | October 23rd, 2003 12:40 PM |
subtracting dates to give a whole number | Lasitter | Worksheet Functions | 2 | October 1st, 2003 09:14 AM |