Date changed when exported to excel (01/01/1900 to 02/01/1900)

[Jerinfonterra]

Date 01/01/1900 in PBI report when exported to excel is shown as 02/01/1900 . There is change in only this date and all other dates remain the same.

[Anonymous · Accepted solution]

Hi @Jerinfonterra ,

Regarding your question, in Power BI, 2 means '1/1/1900', while 1 means '12/31/1899'. In Excel, 1 means '1/1/1900', and 2 means '1/2/1900'. This is a very old error, and it was not synchronized until '3/1/1900'.

When you export data with the date '1/1/1900' to Excel, you are actually passing the number 2.

It is recommended that you change the data type to 'Text'.

Related articles.

Dates differences between Excel and DAX - SQLBI

Best Regards,
Wenbin Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.