Decrease value each week

Hi,

I currently have an excel file that I edit every Tuesday (I've asked questions here before). However I feel that there could be a formula somewhere that will help cut down the tedium involved when updating it.

In my spreadsheet I have a column of values that would look like this:

....D1....
.....4......
.....5......
.....21....
.....1.....

They are all whole values and every Tuesday they need to all decrease by one.

So the above would look like:

....D1....
.....3......
.....4......
.....20....
.....0.....

(Sorry for being a bit obvious)

Once the value reaches 0 I will just delete that row of data manually (as it won't be of interest any more).

So what I was wondering was, is there are formula that would do this automatically? I already have one that increases a value by 0.1 every Tuesday so it would work around the same principle, right?

It would save me a lot of time as the data is always increasing...

Cheers!

Init.

Hi,

Attached is a starting point ... for cell D2 ...
You will need to keep track of your latest updates ... to ensure only one weekly update ...
HTH

Thanks, but it's not really what I'm looking for. I'm looking for a formula like this one:

=INT(16.07)+DOLLARFR((ROUND(MOD(16.07,1)*100,0)+INT((TODAY()-DATE(2010,2,2))/7))/12,12)

This one increases a value by 0.1 each Tuesday. Surely there would be a way to manipulate this formula so it decreases a value by 1 each Tuesday?