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)
But my result looks like this:
<tbody>
</tbody>
When I create a column manually that isn't part of the Pivot Table it works, but when I add a calculated field for the pivot table I get that.
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?
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)
But my result looks like this:
12/12/2012 | 1/4/2013 | 0 |
9/28/2012 | 9/28/2013 | 0 |
<tbody>
</tbody>
When I create a column manually that isn't part of the Pivot Table it works, but when I add a calculated field for the pivot table I get that.
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?