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


"dhstein" wrote:

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.

How about:
=MATCH(VLOOKUP(B1,A:A,1),A:A)
--
Gary''s Student - gsnu200909


"dhstein" wrote:

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.

=MATCH(B1,A:A)
--
David Biddulph

"dhstein" wrote in message
...
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.

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.




"David Biddulph" wrote:

=MATCH(B1,A:A)
--
David Biddulph

"dhstein" wrote in message
...
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.


.