If you are interested in dates only
Have you tried
=max(rng) formated as a date
if the range is dates only this should give you the latest date listed.

If the dates are in one column 1 and you are interested in data next to that
column, that is a different question.

is there only one dtae per entry or can there be several dates entries for a
given date?
"taylord" wrote:

My spreadsheet contains the days of the month & I need the last value entered
to display in a cell. ( not the total but the actual last value entered).
Thanks for any help!