Formula needed

  • Thread starter Thread starter dhstein
  • Start date Start date
D

dhstein

I have a sorted range of dates (in date format) from the past to the future
in column A. Cell B1 has =TODAY(). I need a formula that will give me the
row that divides the past from the future. So if today is 1/20/10 and cell
A75 has 1/15/10 and cell A76 has 2/3/10, the formula should return a value of
75. Thanks for any help on this.
 
Maybe: =MATCH(B1,A1:A100)
Micky
 
All 3 of these worked. David gets extra credit for saving bits. I plan on
using the bit savings as a down payment on my next formula. Thanks guys.
 
Back
Top