Split the Date Using Power Query or Get & Transform
Power Query or Get & Transform (from excel 2016) allows you to split your date into the year, month and day.
You can also browse our Power Query Tutorial Catalog here.
NOTE 1: You can create random excel workbook online here for practice purposes as I did in this tutorial.
NOTE 2: If You use Microsoft Excel Prior to 2016 Version, then You Need to download Power Query Separately.
Previously In Power Query: How to Split the Time Using Power Query?
STEP1. Firstly, select your data and press the shortcut Ctrl + T or by going to Insert > Table then it will turn into Excel Table.
STEP2. Now in the second step follow this procedure:
For Office 365 or After 2016: Go to Data > Get & Transform > From Table
For Excel 2013 & 2010: Power Query > Excel Data > From Table
STEP3. Now Power Query Editor is opened so no let’s try to get the Year, Month and Day.
Select the Order Date column and follow this:
Go to Add Column > From Date & Time > Date > Year> Year
Once again select the Order Date column and follow:
Go to Add Column > From Date & Time > Date > Month > Month
Ensure to select the Order Date column and then follow:
Go to Add Column > From Date & Time > Date > Day > Day
STEP4. Now open a new worksheet in excel with those updated records by clicking the Close & Load from that Home Tab.
Here is your result with the dates split into Year, Month and Day.