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?
Bookmarks