Hi,

I have one cell that the contents is a date that you shall be to change. This date is put in the format of 2007-02-06 (cell N8).

In order to get the advanced filter to work, I need the cell that shall be used as criteria to contain a text string like the following:
=">=2006-06-01"
and to get this, I have found that I can use the formula
="="">="&N8&""""
But then the advanced filter will not work. Do I need to somehow convert this formula to a static text string to use when filtering? If yes, how do I do that?

Hmm, I hope everyone understands my description :D