Insert Last Date Value in a Column into a cell

[db]

I've created a billing register for a client with the "Date of
Transaction" in column A (A8:A508). At the top of the sheet, I have a
cell with an "As of" date value. What I need this cell to do is read
column A and find the last date entered. I've tried an array function,
but it only seems to work with number values, not date values.

Any help would be greatly appreciated! Thanks!

~db

 

[Ardus Petus]

=INDEX(A8:A508,COUNT(A8:A508))

HTH

 

[Paul B]

db, one way, format the cell as as a date

=LOOKUP(9.99999999999999E+307,A:A)
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[db]

Thanks for the help!

Is there any way to account for blank rows in column A? When I pasted
the function in, it worked great, provided I didn't have any blank rows
in column A, but is there any way to take this into account if the
client accidently skips a row, or chooses to skip a row when entering
in a date?

Thanks again!

 

[Sandy Mann]

Dates are really just numbers so to return the latest date try simply:

=MAX(A8:A508)

--
HTH

Sandy
In Perth, the ancient capital of Scotland

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[db]

Thank you Sandy! Great Idea!