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.