LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Show dates based on criteria slaga Excel Worksheet Functions 3 May 7th 08 06:26 PM
Counting dates based on certain criteria steve_sr2[_2_] Excel Worksheet Functions 5 March 1st 08 12:42 AM
Counting unique dates based on selected criteria in a list orchid11652 Excel Worksheet Functions 1 July 25th 07 12:08 AM
columns to rows based on record criteria AA81 Excel Worksheet Functions 1 June 4th 07 10:50 PM
Criteria Lookup based on Dates Tyson Excel Discussion (Misc queries) 2 December 15th 05 08:26 PM


All times are GMT +1. The time now is 05:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"