=(TODAY()-39113)*100/15+100
--
Gary's Student
gsnu200705


"Ken" wrote:

i want to capture the calulated vlaue of a cell based upon the date. i.e. on
1/31/07 b2=100. on 2/15 it continues to update the calulation and now b2=200.
is there a function/formula i can use to capture what b2's calculated value
was on 1/31?