[libreoffice-users] Re: Filter rows of certain dates, LibreOffice Calc

Am 22.07.2012 13:27, Johnny Rosenberg wrote:
> I searched for Standard Filter examples and the only thing I found had
> a string or a number in the Value fields. I want to use an expression
> instead, but that doesn't seem possible, or maybe I'm just doing it
> wrong.
> For example:
>
> Column A    >=   Today()-7
>
> Doesn't work at all. The only thing that happens is that rows not
> containing a date at all in Column A are hidden. In this case I only
> want to hide those rows older than a week. I guess I am just not doing
> it right, right?
>
>
>
> Kind regards
>
> Johnny Rosenberg
> ジョニー・ローゼンバーグ


Data>Filter>Advanced Filter...
Point to a 2-cell range with column label and calculated value.

Cell #1: =$A$1
Cell #2: =">="&TODAY()-7




--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted