Convert cell reference to text string

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

When selecting "Format Cells" and "Date", that format is there for me to choose.

Nevermind the format, it works for me and I can choose it. But that ain't the problem.

What can be done to solve the problem?

hello packe

You shouldn’t need to convert anything to text. You can use a formula for this in the criteria range.

Criteria label should be blank.

Put this formula in the criteria range

=A5>=$N$8

where A5 is the first record in your advanced filter list range and N8 contains a date. Note: the cell containing the formula will return TRUE or FALSE but that won’t affect how the filtering works