Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/
Learn how to fix date errors in Power Query. The video covers four different ways including:
1. Adjusting the locale for individual columns.
2. Changing the regional settings for the entire file.
3. Changing the regional settings on your operating system.
4. Using the “Columns From Examples” feature to decipher the correct formatting and apply it to your query.

If you’d like to read the corresponding blog post for this video on my website, you can find it here: https://www.excelcampus.com/powerquery/power-query-date-errors-settings

Related Videos:

Convert Text to Time Values with Power Query: https://www.youtube.com/watch?v=1h94nq4if28

How to Install Power Query in Excel 2010 or 2013 for Windows: https://www.youtube.com/watch?v=gwW2CDdvUUs

How to Unpivot Data with Power Query in Excel: https://www.youtube.com/watch?v=Kbu5RkUo6-k

Preview of PowerQuery, Pivot Tables, and Dashboards Video Series:
https://www.youtube.com/watch?v=WYfIgthJjFE

#MsExcel #ExcelCampus
00:00 Introduction
00:57 Local Settings
02:16 Regional Setting
04:30 Changing Regional Settings
06:40 Convert Dates