Pick last date in a column if more than two similar dates

[MSSailor]

Have to lookup for the last day in a column A, The thing is that if I have
more than one similar date, it takes the first one in the column.

Column A
2009-03-03
2009-03-04
2009-03-05
2009-03-06 Mentioned formula picks this value
2009-03-06 I WANT THIS ONE..........

How to add the formula to look after the last day and pick the last value?
This what I have now!
=VLOOKUP(MAX(A9:A36),A9:L36,COLUMN(A20),FALSE)

 

[Dave Peterson]

If you always want the last thing in that column and there are no gaps in the
range, you could use a formula like:

=index(a:a,counta(a:a))

 

[FARAZ QURESHI]

=LOOKUP(2,1/(B1:B20=A1),C1:C20)