View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
OssieMac OssieMac is offline
external usenet poster
 
Posts: 2,510
Default advanced filter issue

Hi Joseph,

I'm confused by your start date and end date. "start date <=21/02/2009 & end
date =19/02/2009". How can you have a project End date that is earlier than
the Start date?

--
Regards,

OssieMac


"Joseph Atie" wrote:

Im trying to filter a data set on 3 criteria

project name, start date, end date

the project name part is fine the problem im having is that im getting dates
outside of my date range

im using the following

start date <=21/02/2009 & end date =19/02/2009

im getting dates start after the start date, but not before

all three filter criteria are on the smae line, which to my understanding
means

project name & start date & end date

help please