if you want to know the last row
=MATCH(9999999,a:a)
if you want the last value
=INDEX(B:B,MATCH(9999999,B:B))
Post back if this is NOT what you want.

On Jan 13, 5:45*am, mag wrote:
I would appreciate if someone can help me with this

In first column I will type date in some free format

1.01.2012.
3.01.2012
10.01.12.
11.01.11
blank
blank
blank
...

in one cell at the end of table I would like to have the formula that
will show me or will copy last input (date, string or cell value) in
column or defined range (for instance: A5:A35)

is it possible to use formula in one cell for this in Excel 2007

thanks in advance

DMag