How can I automatically update data on a certain day?
 

I want to update certain cells on certain days. Like on Wednesday, c8 becomes
c8+1. then like after i want on thursday and so on, c8+1 becomes the new c8
to make much easier, i'll make a timeline:
tuesday: c8 is 53
wednesday: c8 is 54
thursday: c8 is 54
next wednesday: c8 is 55
the wednesday after that: c8 is 56
In a nutshell, c8 updates weekly

How can I automatically update data on a certain day?
 

Assuming that you want the step from 53 to 54 to be today (Dec 19th), then
try
=53+INT((TODAY()-DATE(2007,12,12))/7)
--
David Biddulph

"Four-Eight" wrote in message
...
I want to update certain cells on certain days. Like on Wednesday, c8
becomes
c8+1. then like after i want on thursday and so on, c8+1 becomes the new
c8
to make much easier, i'll make a timeline:
tuesday: c8 is 53
wednesday: c8 is 54
thursday: c8 is 54
next wednesday: c8 is 55
the wednesday after that: c8 is 56
In a nutshell, c8 updates weekly