Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Adding A Set Number Once a Week?
Need to keep track of how much rent I've paid ona weeks basis. How can I figure a function to add a certain amount once a week? -- HeatherDawn ------------------------------------------------------------------------ HeatherDawn's Profile: http://www.excelforum.com/member.php...o&userid=16788 View this thread: http://www.excelforum.com/showthread...hreadid=319861 |
#2
|
|||
|
|||
Assuming you pay today, and your rent is in A1, here's one way:
=INT((TODAY()-DATE(2004,11,23))/7+1)*A1 In article , HeatherDawn wrote: Need to keep track of how much rent I've paid ona weeks basis. How can I figure a function to add a certain amount once a week? |
#3
|
|||
|
|||
Anyway to do it automatically? Or does this do automatically? -- HeatherDawn ------------------------------------------------------------------------ HeatherDawn's Profile: http://www.excelforum.com/member.php...o&userid=16788 View this thread: http://www.excelforum.com/showthread...hreadid=319861 |
#4
|
|||
|
|||
If you're referring to the solution I provided, it will work
automatically. Just put in the correct start date in the DATE() function. In article , HeatherDawn wrote: Anyway to do it automatically? Or does this do automatically?-- |
#5
|
|||
|
|||
TY!! Works like a charm! -- HeatherDawn ------------------------------------------------------------------------ HeatherDawn's Profile: http://www.excelforum.com/member.php...o&userid=16788 View this thread: http://www.excelforum.com/showthread...hreadid=319861 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need week number in excell from a date, first week must be mini. | Excel Discussion (Misc queries) | |||
Adding + in front of a number | Excel Discussion (Misc queries) | |||
Dynamic Column VlookUps Based on Week Number | Excel Worksheet Functions | |||
Convert week number into calendar month? | Excel Worksheet Functions | |||
Returning the Week Number of a Specific Date on a Month | Excel Worksheet Functions |