Find Last Row in column not greater than current date

[maacmaac]

A have a spreadsheet ("destination table") with data and I need to pull data from another table ("source data"). In column B of the destination table is list of dates. I am trying to calculate the last row in column B, however, I don't want, nor do I need the last row calculation to go past current date.

For example, assume current date is 10/25/2010.
Dates are as follows:
Cell B253 = 10/15
Cell B254 = 10/22
Cell B255 = 10/29
Cell B256 = 11/05

Please Login or Register  to view this content.

When I search for last row in column B, the last row s/b row 254. Is there any why to calculate this? Attached is sample if needed. Thanks.

[rylo]

Hi

try something like:

Please Login or Register  to view this content.

rylo