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
Bookmarks