If the dates are in Microsoft Date/Time format (not an ascii string) the
simply use VLOOKUP. the 3rd parameter range_lookup should be FALSE. The
dates in the tabler need to be in increasing order. Sort the table to get
the dates increasing if they aren't already.

"navin" wrote:

Hi All,

I have spreadsheet, in which col A has dates ranging from 11-1-2005 to
12-12-2009 and the report which i run is used every monday.

Now i want to determine the last row in column A which has the date
less than or equal to the date on which i am running my report.

ex.

if i run my report on 03-12-2007, then i want to determine the last
row address in col A which has the date equal to or less than
03-12-2007. Here, date 03-12-2007 is the upper limit for the data.

Hope the problem is clear. Please help.

thanks,
navin