change formula to extract data from between two dates

I have a workbook that monitors duel fuel vehicles for cost analysis. At present the output screen draws all of the entries specific to the chosen vehicle number from the entered data worksheet. I have a section that sums the values of the data for entries between two chosen dates. I would like the output screen to only display the entries corresponding to the two dates in use to pre-empt the problems encountered as the entries grow.

The formula in question are in cells starting from b3,c3,d3,e3,f3,g3. The chosen dates are displayed in n1 and p1.

{=IFERROR(INDEX('ENTERED DATA'!$B$2:$H$1289,SMALL(IF(INDEX(('ENTERED DATA'!$A$2:$A$1289=$C$1)*('ENTERED DATA'!$C$2:$C$1289=$M$5),0),(ROW('ENTERED DATA'!$A$2:$A$1289)-1),""),ROW(1:1)),COLUMN(A:A)),"")}

they are array formulas. Any help appreciated.

test file attached

Add date conditions to it:

Formula:

{=IFERROR(INDEX('ENTERED DATA'!$B$2:$H$1289,SMALL(IF(INDEX(('ENTERED DATA'!$B$2:$B$1289>=$L$1)*('ENTERED DATA'!$B$2:$B$1289<=$N$1)*('ENTERED DATA'!$A$2:$A$1289=$C$1)*('ENTERED DATA'!$C$2:$C$1289=$M$5),0),(ROW('ENTERED DATA'!$A$2:$A$1289)-1),""),ROW(1:1)),COLUMN(A:A)),"")}

Make sure L1 and N1 are real (excel) dates. Not just texts which look like a date (this was the case in a sample file)

Try:

Formula:

{=IFERROR(INDEX('ENTERED DATA'!$B$2:$H$1289,SMALL(IF(INDEX(('ENTERED DATA'!$B$2:$B$1289>=DATEVALUE($L$1))*('ENTERED DATA'!$B$2:$B$1289<=DATEVALUE(($N$1))*('ENTERED DATA'!$A$2:$A$1289=$C$1)*('ENTERED DATA'!$C$2:$C$1289=$M$5),0),(ROW('ENTERED DATA'!$A$2:$A$1289)-1),""),ROW(1:1)),COLUMN(A:A)),"")}

DATEVALUE quite often works as expected if text format is close enough to system date format.

Glad to hear that, and thanks for reputation point