Formula needed

[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

 

[Gary''s Student]

How about:
=MATCH(VLOOKUP(B1,A:A,1),A:A)

 

[David Biddulph]

=MATCH(B1,A:A)

 

[dhstein]

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.