Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
HeatherDawn
 
Posts: n/a
Default 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   Report Post  
JE McGimpsey
 
Posts: n/a
Default

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   Report Post  
HeatherDawn
 
Posts: n/a
Default


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   Report Post  
JE McGimpsey
 
Posts: n/a
Default

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   Report Post  
HeatherDawn
 
Posts: n/a
Default


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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
I need week number in excell from a date, first week must be mini. jPeich Excel Discussion (Misc queries) 4 January 5th 05 02:21 AM
Adding + in front of a number Ted Metro Excel Discussion (Misc queries) 3 December 29th 04 11:45 PM
Dynamic Column VlookUps Based on Week Number TLK40us Excel Worksheet Functions 3 November 14th 04 04:33 PM
Convert week number into calendar month? WickyWick Excel Worksheet Functions 2 November 9th 04 10:01 PM
Returning the Week Number of a Specific Date on a Month arjcvg Excel Worksheet Functions 1 November 3rd 04 05:35 AM


All times are GMT +1. The time now is 09:32 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"