Excel brain burp.

[darkgen]

So, I'm trying to drive excel to allow a filter on a before date to only then show rows of data before that certain date without referencing the actual dates themselves. I just want to show the filtered data only and not the dates which match the filter condition. Basically I wish I could place the date field in the actual pivot table report filter, but doing so loses the ability to then filter on an actual or before or range of dates.

Clear as mud, no doubt.

Cheers, Paul.

 

[Morfik]

In your Data source just add a column with = IF(A1<DATE_YOU_WANT),"YES","NO"). Where A1 is the cell with the date for that line, change as needed.

Then add this column to the pivot table and filter on "YES".

 

[darkgen]

Thanks for the wood ("for the trees")!

=if(cell<=DATEVALUE("dd/m/yyyy"),"Yes","No")

Cheers, Paul.