How can I automatically update data on a certain day?

  • Thread starter Thread starter Four-Eight
  • Start date Start date
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
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do i do 3 data validations? 2
formula help 1
W2K's event logs showed \\?\Volume{107944b6-439b-11d7-9e57-806d6172696f}?Failing HDD? 1
How can I use OFFSET and VLOOKUP together 1
Can I use cell contents as part of a formula? 3
calculating Leave 12
How capture a date variable within a text cell? 4
Sum of data where a condition applies 1

Back
Top