You didn't say what result you want if the date is not present.

One way...

A1 = some date

=IF(COUNTIF(A18:A32,A1),INDEX(ROW(A18:A32),MATCH(A 1,A18:A32,0)),"")

If the date isn't present the formula returns blank.

--
Biff
Microsoft Excel MVP


"Dianne" wrote in message
...
I need hellp with a formula.

In Cell E8 I need to write a formula that will search Column A rows 18
thru
32 and if it finds the date 09/16/2006 it will display the row number.

Any help will be greatly appreciated.
Thanks
Dianne