With dates in column A, try this to find the latest:

=MAX(A:A)

Format the cell as a date. You can use a specific range if you like:

=MAX(A1:A100)

Hope this helps.

Pete

On May 9, 3:09*pm, carol wrote:
Hi,

I need a formula that will serch an array of dates and generate the latest
date in the cell.

Any ideas?