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?