Thread: Count until condition is met and then retain final count
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Fats Fats is offline
external usenet poster
  
Posts: 5
Default Count until condition is met and then retain final count
Appreciate if some sharp individual can assist me with the following issue.

In cell A1 I have a date.
In cell B1 I have a number between 1 and 100.

I need a formula in C1 to count the number of days between today and the
date in A1 until the number in A2 = 100.
However, Once A2 = 100 I need the formula in C1 to retain the final number
of days counted.
--
Cheers
Ant.
Reply With QuoteReply With Quote