With dates in row 1 an data in row 2...

For the leftmost (first) number 0...

Array entered** :

=INDEX(A1:J1,MATCH(TRUE,A2:J20,0))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.

Format as Date

For the rightmost (last) number 0...

=LOOKUP(1E100,1/A2:J2,A1:J1)

--
Biff
Microsoft Excel MVP


"Kobus" wrote in message
...
I have various rows with numbers entered randomly with 0's inbetween. The
first row has are represents calender dates. I need to find the date of
the
first number entry and the date of the last number entry larger than 0.
If
of any help the numbers entered are from 1 to 6. These are randomly
entered.