How can I automatically update data on a certain day?

F

Four-Eight

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
 
D

David Biddulph

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)
 
Top