Gary's Student,

This appears to calculate the value on 1/31 based upon the exmaple I
provided. I am interested to see if i can automatically capture the value of
a cell on 1/31 that will continue to update regularly based upon data being
entered in a number of sheets. I am trying to avoid having to manually on
each month end date manually type the value of a cell.

"Gary''s Student" wrote:

=(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?