Hello everyone.

I have a pivot table that has two columns that contain dates.

I am trying to add a column with a OR formula that returns true or false base on whether the first date is equal to the second date OR the first date +1 equals the second date.

The formuala I use is

=OR(FirstDate=SecondDate,FirstDate+1=SecondDate)

When I create the column manually so that it isn't part of the Pivot Table it works, but when I add a calculated field for the pivot table I get all zeros.

The field is formatted as General. When I change it to short date I just get 1/0/1900.

Thoughts on what is going on here? Or is there a way that I can just add the column I created manually to the pivot table?