Hi there,

I was wondering if anyone could give me some pointers as to where to
start with the following?

I have a spreadsheet of data in a table. One of the fields is date. I
would like the user to be able to enter a date range and have all the
records returned that fall within that range.

What function should I use for that? DGET can only return one record.
Could I use something like VLOOKUP in an array? The number of records
returned will obviously change depending on the date range entered.

Or, should I use something like a VBA loop?

I need to do this in Excel - it can't be in Access.

Any help would be much appreciated.

Many thanks - David