For the last numerical value, try...

=LOOKUP(9.99999999999999E+307,Range)

Hope this helps!

In article .com,
"ChuckF" wrote:

I have a spreadsheet where date fields are being entered in columns J
through Z. (each column represents a "Week ending date"

I am creating a spreadsheet where I would like the date of the last
(furthest right) column is entered. So if J6 has a date of 2/26/2006,
and K6 has a date of 3/5/2006, I want to auto populate 3/5/2006. But
once something is entered in L6, I want it to populate that.

Thank you in advance for taking the time to think this through for me.