Find and remove specific text?

[Xenoun]

Hello,

I currently have a column in a sheet which has a lot of date listings. These dates come from the "row labels" section of a pivot sheet.

I've previously been unable to just extract the dates which display in the pivot table (the amount of rows in the table changes dynamically) so as a partial fix i've just grabbed all rows from the first date downwards until around the 700th row.

The problem i'm getting because of this is that under the last date all the cells show 0/01/00. When i use this column of dates in a graph it messes the graph up quite seriously.

Is there a way for me to remove the 0/01/00 dates from the cell and just have it blank whilst still keeping the formula in the formula bar?
Or is there a way for me to copy across all the dates that aren't 0/01/00?

Thanks for any help

 

[texasalynn]

remove that data from the pivot table by clicking on the drop down and uncheck that item

 

[Xenoun]

The data isnt in the pivot table. I want all of the dates that are in it but can't figure out a way to set a dynamic range that just grabs what is in the pivot table.

Due to that, the data I get goes below the pivot table and any empty cell gives me 0/01/00