You can use a formula like:
=MAX(C:C)
to find the biggest date in column C (if column C contains nothing but dates)

To return the value in the column D that matches the biggest date:
=INDEX(D:D,MATCH(MAX(C:C),C:C,0))

Debra Dalgleish has some nice notes for =index(match()) at:
http://www.contextures.com/xlFunctions02.html

Aviator wrote:

I have a box (cell) at the top of the page in which I want it to search a
column for the latest date. Once it finds the latest date it takes the data
from a cell in the same row as the latest date. Can this be done? If so, how?

Aviator

--

Dave Peterson