Excel pivot count to exclude specific date value

[stct80]

Greetings!

We have an exported file (from MS Project) having a 'Actual Finish Date' column. This specific column carries value of "Jan-1900" against 'NA" values in MS Project file.

I am trying to run a pivot chart on this exported file - to exclude (not to count) values of 'Jan-1900' in the pivot bar.

Is this possible? When I tried using the formula IF(AI2<>"Jan-1900",AI2,""), pivot still counts the value.

Any suggestion please?

Thank you in advance...

 

[theBardd]

Have you tried

=IF(AI2<>0,AI2,"")