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
|