How to convert Excel integer date to date

[webportal]

My date is a number in Excel-like format:

43957,96837

How to convert this into a date in "dd/mm/yyyy" format in Power BI?

Thank you.

[webportal]

It is 1.1.1900

🙂

Thanks!

[amitchandak · Accepted solution]

@webportal , I think you should be able to get date like

date(1970,01,01) +[col]

or

date(1900,01,01) +[col]