KNOWLEDGE BASE

How to Convert Excel Serial Number to Date with Tableau


Published: 06 Nov 2021
Last Modified Date: 08 Nov 2021

Question

How to convert Excel serial number displayed on Tableau to date field.

Environment

  • Tableau Prep Builder
  • Tableau Desktop

Answer

Use DATE function to create a calculation field like below to convert excel serial number to date field in Tableau

+ date range:  1900/1/1 - 1900/2/28

DATE( INT([Excel Date Number Field] ) - 1 )

+ date range: 1900/3/1 -   

DATE( INT([Excel Date Number Field] ) - 2 )

 

Additional Information

Tableau treats 1900/1/1 as 0, while Excel treats 1900/1/1 as 1.
There's no value for 1900/2/29 in Tableau, but it is 60 in Excel.
 
Did this article resolve the issue?