hi Roger,

Thanks for your answer but the issue is not with a cell being locked or not,
and <$H$5 would anyway not exclude the date, it would take all those smaller
than.... but I wouldn't get the ones bigger than.... And I need both, i.e. I
need to exclude from a list of dates comprising of all dates possible in a
month, 2 dates, i.e. 10th September and 15th September, per ex. that would
be amendable.

My formula would refer to these 2 changing cells.

I'm stuck because auto-filter doesn't recognise cell references and advanced
filter doesn't recognise

Due Date
<$H$5

I tried an IF but when I put <H5 in the criteria, it returns #REF

Anybody has an idea how I can proceed?

Thanks

Sarah

"Roger Govier" wrote:

Hi Sarah

It sounds as though the test should be <$H$2 or <$H$3 rather than the
formula you have

--
Regards
Roger Govier



"Sarah" wrote in message
...
I have a large data-base type spreadsheet where each line has a due date.

In 2 cells above the data, I have due dates that change every month, the
user types in the 2 due dates that change monthly.

I would need to filter the records to exclude these 2 dates.

The user should not have to create a filter himself, only change the
dates.

Using auto-filter, the problem is that I cannot use "does not equal" with
a
cell reference.

Using advanced filter, it does not recognise <(H5)

Any suggestions?

Many thanks
Sarah