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.

How to Split the Date Using Power Query 1

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

Split the Time Using Power Query

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

How to Split the Date Using Power Query 2

Once again select the Order Date column and follow:

 Go to Add Column > From Date & Time > Date > Month > Month

How to Split the Date Using Power Query 3

Ensure to select the Order Date column and then follow:

Go to Add Column > From Date & Time > Date > Day > Day

How to Split the Date Using Power Query 4

STEP4. Now open a new worksheet in excel with those updated records by clicking the Close & Load from that Home Tab.

How to Split the Date Using Power Query 5

Here is your result with the dates split into Year, Month and Day.

How to Split the Date Using Power Query 6