filtering date column

[mp3909]

Does anyone know why when trying to apply a filter to a date column using the "BETWEEN" option where I set is after or equal to =today()-14 and is before or equal to =today() it does not work but soon as I replace the today() with an actual date it works.

[Richard Buttrey]

I'm fairly certain that you can't use formulae like that in the autofilter drop down menu.

You can of course use an Advanced Filter with a criteria range that contains your 'between' dates

[6StringJazzer]

The BETWEEN options (and other filter options) are not formulas, they are constants. You can't use worksheet functions or expressions, only strings.

[jason.b75]

You can not use a formula in the filter criteria boxes. That would require using the advanced filter method.

https://support.office.com/en-us/art...rs=en-US&ad=US

You will need the section titled 'Multiple sets of criteria, one column in all sets'

First criteria

=">="&(TODAY()-14)

Second critera

="<="&TODAY()