try where the 0 is found in row 18
=INDEX(17:18,1,MATCH(0,18:18,0))
--
Don Guillett
SalesAid Software

"Dawnstar253" wrote in message
...
A row contains a series of diminishing numbers. I am looking for a formula
to identify the first zero occuring in the row and return the date
contained
in the same column but higher row.
Any help is appreciated.