Loading

How to Convert Excel Serial Number to Date with Tableau

Data pubblicazione: May 9, 2025
Operazione
How to convert Excel serial number displayed on Tableau to date field.
Fasi
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 )

 
Risorse aggiuntive

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.

Tableau Community:
CSV Serial Date convert to date in Tableau 
 

Numero articolo Knowledge

001460188

 
Caricamento
Salesforce Help | Article