Excel 2007 : Find Date of Last Occurrence

I am brand new to the forum, and this problem has driven me to sign up. I love to learn new things in excel, and hopefully someone can help me with my problem below.

I have a data range D19:J200.

Column D has dates in it. Column J has numbers. I need to find the last value in J that is not zero, and return the date that corresponds to the row.

7/7/2007 0 0 0 0 0 0
7/14/2007 0 0 0 0 0 0
7/21/2007 0 1 0 0 1 1

For instance, I would need to return 7/21/2007 because the lower right value is not zero. Typically I am able to google the answer and figure it out and apply to my situation, but I am coming up with nothing. Really appreciate the help.

Try this array formula

=INDEX(D:D,MAX(IF(J1:J1000<>0,ROW(J1:J1000))))

Bob,

Works like a charm. Thanks much for the easy answer and quick reply.

Do I need to mark this as solved?

Would be good.