Pivot table filtering date to date

Hello. I'm using this code =IF(AND(($I$1-[@DATE]),($I$2-[@DATE])),"no","yes") what I'm trying to do is to have 20 days say yes the rest say no. The only problem is only 2 days says yes and the rest says no

What is wrong with this code? Can anyone help me?

What about this;

Formula:

Please Login or Register  to view this content.

And your data is not in a pivot table.

Originally Posted by kersplash

What about this;

Formula:

Please Login or Register  to view this content.

Thank you for reply. It did not work. Actually it worked the other way around. It displayed all the dates but and ignored all the dates that was in between.

Originally Posted by sktneer

Please try this...

Please Login or Register  to view this content.

This one worked thanks.

Originally Posted by sovietchild

Thank you for reply. It did not work. Actually it worked the other way around. It displayed all the dates but and ignored all the dates that was in between.

Just flip the yes and no around.