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

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