Here is an example with rows 8 and 9

=INDEX(8:8,,MIN(IF(9:9=0,COLUMN(9:9))))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"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.