Sep 20 2023 05:54 AM
Hi,
I'm using several plan to into planner to track multiple project. I have also build a dashboard with excel and power query. However, planner export my plan in two date format into two different plan. it's giving me hard time. How can I change the date format in the excel planner export tool so all the date format are all the same?
Thank you,
Pierre Luc
Sep 20 2023 07:27 AM
Hi @PLHebert,
There are two ways to change the date format in the Excel Planner export tool:
Change the date format in Power Query:
Open the Excel file containing the Planner export data.
Click on the Data tab.
In the Get & Transform Data group, click on From Table/Range.
Select the range of cells containing the Planner export data and click OK.
The Power Query Editor will open.
In the Power Query Editor, click on the column header for the date column.
In the Transform tab, in the Data Type group, click on Change Type.
In the Change Type dialog box, select Date from the Data Type drop-down list.
Click OK.
In the Power Query Editor, click on Close & Load.
This will change the date format in the Excel file to the date format that is specified in the Power Query Editor.
Change the date format in Excel:
Open the Excel file containing the Planner export data.
Select the range of cells containing the date column.
Press Ctrl + 1.
In the Format Cells dialog box, click on the Number tab.
In the Category list, select Date.
In the Type list, select the desired date format.
Click OK.
This will change the date format in the selected cells to the desired date format.