Roger

Thank you for your help, I'll give that a try.

Whilst on the subject of filters, are you allowed to perform an advanced
filter where your list range consists of two columns from a main table that
are not next to each other?

For instance, I have names in column A and a membership number in Column D,
with other data in B and C. I have tried to perform a filter that will just
put the people's names and membership number on a separate worksheet but it
keeps saying the list is invalid. Is that why?

Thanks again.

Louise

"Roger Govier" wrote:

Hi Louise

When I use dates in Advance Filter, I tend to put the date in a cell outside
of my filter Criteria range.
Then in the criteria cell I put
="="&C8 where C8 holds the date as 27/10/2005
It shows up as =38652

Regards

Roger Govier


Louise wrote:
when i type this formula into the cell, it automatically turns into 34700,
rather than keeping the actual criteria there??

"bpeltzer" wrote:


You'll have to help Excel understand the 1/1/05. Change the date criterion
to =" "& DATE(2005,1,1). With the DATE function, you can understand and
change it, and Excel can convert it to a number for its use in the filter.


"Louise" wrote:


I have a worksheet containing various data, including staff names, their
start date and the department they work for.

I am trying to use an Advanced Filter which will give me a list on another
worksheet of those staff who started after a particular date but, for some
reason, I can't get it to work.

My 'criteria' looks like:-

Name Start Date
01/01/05

I have made sure that al the cells containing dates are formatted in the
same way but it still doesn't work.

I have created quite a few filters and they have all worked fine, apart from
when I try to use dates.

Any ideas what I'm doing wrong???

Thank you.

Louise