Forum Discussion
Changes in date after importing från query in excel
Hi! I've got an excel file with data (different measurements for water quality) from january 1980 to december 2018. I open the table in power query från excel to make quick changes in format in...
Solved! The problem was that the dates and the file were formatted in mac. I followed the linked tutorial (but instead of substracting 1462, I added the same number) and changed the settings as the tutorial discribed.
https://excelsemipro.com/2010/06/microsoft-excel-date-systems-for-windows-and-mac/
https://excelsemipro.com/2010/06/microsoft-excel-date-systems-for-windows-and-mac/