Insert Last Date Value in a Column into a cell

D

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
 
P

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
 
D

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!
 
Top