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.

Please Login or Register  to view this content.

they are array formulas. Any help appreciated.

test file attached

Add date conditions to it:

Formula:

Please Login or Register  to view this content.

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:

Please Login or Register  to view this content.

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