How to convert a MM-DD-YY date to DD-MM-YY in Excel  \ Power BI -  Power Query #shorts
Channel: Efficiency 365 by Dr Nitin
Date: 2022-07-11

Solve a common problem. Direct import in Excel does not work if the incoming data is in mm-dd-yy format and your PC is set to dd-mm-yy format.
Using Power Query, with the Locale option, this problem is easily solved.

Here is a list of different date formats by country
https://en.wikipedia.org/wiki/Date_format_by_country

It does not matter which country you choose as long as it has the desired DATE format.
Here is a simple list of date formats you need and related country
DMY - India
MDY - USA
YMD - Japan


Buy Dr Nitin's latest book
-----------------------------------------
Efficiency Best Practices for Microsoft 365
130 best practices everyone must know
Work Smarter, Grow Faster

https://s.efficiency365.com/bk

Dr Nitin Paranjape is the pioneer in maximizing work efficiency in a modern work scenario.
Dr Nitin's Office Masterclass
----------------------------------------------
https://hi.switchy.io/mms

Udemy Courses by Dr Nitin Paranjape
--------------------------------------------------------------
Pivot Table Advanced - https://hi.switchy.io/22B1
Excel to Power BI - https://swiy.io/pivotsh

Learn more from 1000+ blog articles by Dr Nitin Paranjape 
Efficiency 365 blog: https://efficiency365.com/blog

LinkedIn : https://www.linkedin.com/in/nitinparanjape/
Twitter : https://twitter.com/drnitinp

Production
--------------------
Music and Effects: https://www.epidemicsound.com 
Created using Camtasia: https://www.techsmith.com/video-editor
AI based captions: https://videoindexer.ai (Microsoft service)