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