Worksheet 1 contains weekly data, for example cells A1 thru A4 contain dates,
the other cells are still blank :

1/3/07
1/10/07
1/17/07
1/24/07
<blank cell
<blank cell

What formula can I enter in a worksheet 2 cell to display the last date in
the list?

Thank you in advance for your help.

Shelly