I found the same thing happening in Tableau 10.0 - Also tried using Floor to eliminate the decimal part of the "excel data/time" and that did not resolve the issue - Note the problem is the same for all date - not just those over the end of the year
2 of 2 people found this helpful
Excel's epoch date (day 0) is December 30, 1899. Tableau's epoch date is January 1, 1900, two days later.
Therefore if you have dates stored as numbers in Excel and are doing the conversion in Tableau the you'll need to subtract 2 from the number so it works with Tableau's epoch date.
Makes perfect sense, thanks Jonathan!
Jonathan - Thanks - this helped me out of a problem I was having on a viz