Find range of rows containing values between two dates when start date may be missing

I am trying to select a range of rows based on date values which are in one column, the dates are ascending but are repetitive and some dates may be missing. e.g.
11/Jun
11/Jun
11/Jun
12/Jun
12/Jun
14/Jun
14/Jun
14/Jun
14/Jun
15/Jun
15/Jun
16/Jun
16/Jun
16/Jun
17/Jun

What I want to do is specify a date range e.g 10/Jun to 13/Jun and find the starting row and ending row of the range containing all data related to these dates. (In my database sheet the adjacent columns to the dates contain production information)

Is there any way I can specifiy the date range as 10/Jun to 13/Jun and (given that these two dates are missing) then identify the 1st row as being the first date higher than 10/Jun and the last row as being the last occurrence of a date less than 13/Jun.

The idea is to be able to specify any period, then identify the range of rows containing all the values between the two dates as quckly as and then use arrays to to transfer the selected datarange from the 'database' sheet to a report sheet.

If I can get the range of rows I can quickly copy the data to an array and then write the array to the new range. I have tried all sorts of Match, Index/Match, Lookup type formulae to try and get the start and and rows based on the specified dates but as soon as one of the dates is missing this results in a formula error #N/A.

It is part of a report generating spreadsheet which gets production for each day during the production period and lists the production statistics, there are multiple entries per day when production is in progress but there may be missing dates due to no production. I have been able to achieve a workaround solution to the problem by reading each row of the data list one row at a time with a loop and then a conditional statement to select only those rows that containing dates falling between the given values and writing them to a new range of rows but this results in a very slow read/write operation.

The missing dates are giving me a real headache but cannot be avoided, once I can identify the extents of the data range I can use much faster arrays to transfer the data from the 'database' sheet to the report sheet.

Many thanks
Jon

I am not sure how to do this within a VBA macro.

The whole routine is generating a 7-day period report based on the date entered in one cell. On entering the date the macro will generate a report containing all the necessary production statistics for the 7 days preceding the entered date, the rows of production data I am trying to identify are just one part of a more comprehensive report.

Rgds,
Jon

You have the problem in a nutshell, it is much faster to read and write by reading data to an array in memory so I think that my solution will be this,

1) Find the last valid row of the database
2) Select the whole database range - in this case Range("A3:O" & LastRow)
2) Read the whole database into an array (it will be a couple of hundred rows and 15 columns)
3) Search the first element of each record (essentially the column A dates) for all values which are => than 'Date1' and <= 'Date2' and output those records to another array.
4) Read from the output array and write to the report page.

Have only got to test point so far but it reads and writes much faster than using do and copying each relevant row from the database to the report by using loops and range copying.

Writing to and Reading from an array in memory is fast and data looping through the array to select the data within the date-range is very quick so I do not need to find the start and end 'rows' first.

Will see how I get on but looks promising so far.

Cheers
Jon