| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| update data automatically | Excel Discussion (Misc queries) | |||
| Automatically Update Chart(s) with new data. | Charts and Charting in Excel | |||
| Automatically update data across worksheets | Links and Linking in Excel | |||
| how do i get the data in a chart to automatically update? | Charts and Charting in Excel | |||
| Update data automatically among worksheets | Excel Discussion (Misc queries) | |||
Linear Mode
