View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ken Ken is offline
external usenet poster
 
Posts: 590
Default Capturing a cell value as a function of a date

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?