Auto detect the range depending up on the input date.

[SR]

Hi All,

I have an excel as below. If I give the date as input, suppose 6/1/2009,
excel should do a count if function with the range starting from the 1st cell
below the input date till the next date in the dates column. I am confused,
please help.
6/1/2009
N New 291420 Roger
N New 291425 Fred
N New 291427 Lisa
N New 291532 Lima
N New 291741 Lisa
N New 291531 Roger
N New 291494 Roger
6/2/2009
N New 291532 Lima
N New 291741 Lisa
N New 291531 Roger
N New 291494 Roger
6/3/2009


Thanks,
S

 

[Cheetahke]

Where do you give the date as input? In the same sheet? In another sheet?