Assuming your dates are in Row 1, from column A to column BJ
Assuming that numbers are in Row 2, and that rows 3 and 4 are clear,
for use as helper rows.

in A3 put =IF(A2<0,A1,"")
in B3 put =IF(AND(B2<0,A3=""),B1,A3)
and formula-drag this to BJ3

in BJ4 put =IF(BJ20,BJ1,"")
in A4 put =IF(AND(A20,B4=""),A1,B4)
and formula-drag this to BI4

In BJ3 is the date of your first negative number
in A4 is the date of your last positive number

Hope that helps and is what you needed.


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=390699