If you apply a filter to the date column for the selected date you can
then just highlight the visible rows and copy/paste or cut/paste them
elsewhere (eg another sheet) to extract them.

Hope this helps.

Pete

On Mar 10, 9:08*am, Code Numpty
wrote:
I probably didn't title this too well.

I have a spreadsheet with 500 rows of data, sorted by the date in column A.
I want to extract certain data from rows that all start with the same
specified date.

Previously I used an IF formula but that necessitates having the formula in
500 rows which won't work for my purposes.

I'm going round incircles trying to think how best to achieve this.