Use the datevalue function.

Cheers

Greg Locock

Or try using a pivot table...

to me the date value function is not the answer, all it seems to do is convert the date to a number, perhaps i made my question unclear.

I have a list of parts inspected, the parts are inputed on a day by day basis, on any typical day there will be 30 - 40 results. I want to be able to come along an extract all this data to another sheet for any given day, preferably a week. I know filters could do it, but its automating it and pulling it to another sheet thats the problem.

i know it would be easy in access but hey acess is for wimps lol, or more likley im dire at it.

Lets's assume your data is arranged as follows:-
A3 : Heading "Date"
B3 : Heading "DataValue"
A4 to A999 or whatever : actual dates
B4 to B999 or whatever : corresponding data values


Then in cell A1 enter the earliest required date,
 and in cell A2 enter the last required date.

Then add an extra column C in your data table , with
C3 : Heading "SelectedData" and the following formula (replicated down for all rows of data)in cell
C4  : =if(and($A3>=$A$1,$A3<=$A$1),$B3,"")

Now by using autofilter on the data list, you can just select "NonBlanks" for "SelectedData" in the filter criterion dropdown list, and only the data rows for the required data range will show, and you can then easily copy those rows to paste wherever you want.

Apologies - correction of formula, should be
=if(and($A3>=$A$1,$A3<=$A$2),$B3,"")

Apologies - I shouldn't have rushed in - further correction of formula in C4, should be
=if(and($A3>=$A$1,$A3<=$A$2),$B4,"")