Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Schedule Changes based on dates
Does anyone know how to schedule an automatic change based on real time date
and time. Example: I have a rate sheet for which I have to make changes all the time, I am told 30 days in advance of the changes that have to be made. What I want to do is find out a way I can make the changes to certain cells today and schedule them to take effect at a later date automatically. Is this even possible? -- Jheison |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Schedule Changes based on dates
Hi
Perhaps you could create a 2 column table on another sheet with the first column having the date and the second column the Rate e.g. 0 5.0% 01 Jan 08 5.5% 01 Feb 08 5.6% Then use something like =A1*VLOOKUP(date_value,Sheet2!$A:$B,2) where date_value is some cell containing the date concerned. The rate of 5% would be used to multiply the value in A1 for any date up to 31 Dec 07, and 5.5% would be used from 01 Jan to 01 Feb etc. -- Regards Roger Govier "jheison" wrote in message ... Does anyone know how to schedule an automatic change based on real time date and time. Example: I have a rate sheet for which I have to make changes all the time, I am told 30 days in advance of the changes that have to be made. What I want to do is find out a way I can make the changes to certain cells today and schedule them to take effect at a later date automatically. Is this even possible? -- Jheison |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
Create patient schedule based on master therapist schedule | Excel Discussion (Misc queries) | |||
EXCEL - need help with IF for dates on schedule | Excel Worksheet Functions | |||
How to Auto fill dates on a schedule | Excel Discussion (Misc queries) | |||
Formating Dates for production schedule | Excel Discussion (Misc queries) |