View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
HappyDaddy HappyDaddy is offline
external usenet poster
 
Posts: 4
Default Record dates based on criteria

Cell A1 contains a simple addition formula based on two cells that are
manually input

"Gary''s Student" wrote:

Does cell A1 conain a formula or an inputted value??
--
Gary''s Student - gsnu200798


"HappyDaddy" wrote:

How do I record the date when a specific cell reaches a specific value?

ie:
Cell "A1" increases in value based on user input. Starts at zero on day one
and is added to over a period of time.

I would like to record the date when cell "A1" first exceeds a predetermined
value of say...100

I would then like to record the date when it excedds another value of say
...327